ICTCity

That's because I need that you monitor and post results, if not I can't see how much traffic is generated. Anyway... I never heard that you have multiple connection with different IPs and interfaces on the same storage to different disks... I mean... not in this way. Anyway it doesn't matter. Be sure to understand that YOU DO NOT HAVE 16 GB, take a look at the last row: it says BYTES \ s which mean BYTES which are NOT 16 GB ;) 1 GigaBYTES = 1'000'000'000 BYTES Again, monitor and make the copy and paste test :)

even I don't know which interface is the storage one, I take the biggest value (16'126'929) and after some calculation you have 16 MB/s in 5 mins which is... NOTHING! So there's something wrong somewhere. I mean... ok you haven't much traffic but ehi.. 16 MB/s looks pretty bad ^^ Can you please repeat the same thing BUT this time include storage and do what I told you before (copy a file). Post results ;)

*Sorry but you must try this before going further* Can you disable the firewall and retry? Just to confirm that the problem is the firewall.

No problem. Can you tell me how long do your recorded this?

You must create that counter and when you create it add as "sensor" both network interface one for your LAN and the other for the storage network, you told me that you have two separate networks...

WHAT? 12 mb/s??? You may experience timeout from SQL if you have that kind of speed on a query! Well, what you can do is: 1) open performance monitor (you may also start logging and then post) and select the NETWORK STORAGE AND LAN. Then simply copy a medium file from a server to that server (and viceversa), when I say medium I mean no more than 2 gb. Do this 2 times, one time when you have "no load" and the second time when you're almost at full load. 2) if the storage has some kind of monitoring tool... check them too (if you have access). But we can already troubleshoot this problem only from the server side. We need something that proove that the network or the nas is slow. That's obvious, but to proove this, we must first exclude sql, that's because I want the test number 1, moving a file you don't involve SQL ;)

So we will do his job :P Can you please tell me which kind of test have you done? The more you are specific, the more I can help you :)

Remove that check and set manually the value (48000) make sure you have enough space! ahhhhh ok but this is normal! FREE is something different from AVAILABLE but actually you must check the AVAILABLE and not the FREE ;). You still have more than 10 gb ;) Basically the difference between FREE and AVAILABLE is: FREE: it contains 0 (zeros) and actually has never been used (this will always be a small number, some exceptions may apply...) AVAILABLE: this memory has something inside but... it's not required. Some (too many) programs use the RAM and then they forget or don't want to free up the memory completely. So this part of ram is in stand-by. actually is not free (because it has something inside, not used but it's still something), BUT windows or other programs can use it to work ;) Don't watch the free memory, better the available ;)

Remember the anti virus... I had bad experiences with nod32...

Everything looks fine 21 used ;) set the pagefile as FIXED size (use the command provided before) just in case. When happens that you run out of ram, post a print screen with the ram utilization (by process of course). A good point is to create a fixed pagefile, remember to reboot :)

Best practices say that your pagefile should be 1.5 greater than your ram. So if you have 32 gb of ram, your pagefile will be 48 GB. To make this modification, run (as administrator) this command (in command prompt): wmic computersystem where name="%computername%" set AutomaticManagedPagefile=False wmic pagefileset where name="C:\\pagefile.sys" set InitialSize=48000,MaximumSize=48000 This will create a FIXED pagefile of 48 gb. Of course you must first be sure that you have 48 gb free on your disk. I would like to know WHICH process is using so much RAM. Open the task manager and check the MEMORY column. The first value should be SQL, and the second should be the one related to the use of your 12 GB. Let me know.

Glade to hear this :) This is not a common "mistake" but it happens. Anyway if you still notice poor performances we can still further investigate. Waiting for ur next thread :)

Good :) I think you were using something like a single shared disk which is not really good. Anyway keep in mind that the problem comes out AFTER installing SQL... If you need further help feel free to ask :)

Well I want check but 100 mb/s is a good speed. With HDD you can't have too much speed. Even the 100 is not real.

Do not disable SQL, exclude it from nod32 real time scan. It looks like another situation that happened to me. The problem was the same... I hope that if you disable nod32 the situation will be better. If not we must follow the others options.

The picture was taken when the server is at full load?! it's doing nothing... I saw that you have nod32... try to disable the NETWORK DISK SCANNING (I can't remember the exact sentence) and make sure that the SQL executable is disabled. Just to try, disable nod32 and try if the situation goes better.

Yeah I know... PM links to me (upload somewhere).

Ok, I wait until you tell me the perfomances seen on res monitor.

SQL is RAM and DIsk consuming, but a drop from 311 to 22.8 looks a bit too much. Said that... do you have SSDs or HDD? Because 311 it's really a high value! What I think right now is that you have many concurrent operations to your shared storage. If you open the RESOURCE MONITOR and expand the DISK section (do not log, just watch) during queries and so on, do you notice a high value of the process sqlserver.exe OR networkservice.exe or other? When I say high value I mean something greater than 30 MB/s. Another thing. How do you have installed your sql? Windows and sql on the same partition?

So the network is separated... just a question... which services are running on that storage? SQL, then? How many VMs? How many PHISICAL DISKS do you have in your storage?

well more or less yes... Go to the server and type (command prompt) ipconfig and write down the IP. Then do the same thing on the storage (you should login into your dell and somewhere you should see the network configuration), write down all the IPs that you can find. If you prefer you can post pictures. If the IPs are on the same class, then you are on the same network. If you don't know how to notice this, simply post the IP addresses.

Yes you're right. This is called VLANs. Don't spend too much time on the storage config, most of your problems are related to the network ;) trust me.

You've found the solution ;) You're already lucky with 20 MB/s on the same network... really! You should tell somebody (who installed the network) to SEPARATE the networks. So basically: 2 VLANs: 1 for LAN 2 for STORAGE On your windows box you will have AT LEAST 2 NICs one for LAN and the other for STORAGE. Once done you will notice a speed up to 50 MB/s Then of course you may have other problems like bad config of your storage or disks. But usually when somebody tells me that the storage is slow the answer is NETWORK! If you need further help feel free to ask.

Hi, I have many ideas but first a question: Yours disks are on the LOCAL SERVER or on a SHARED STORAGE (NAS - SAN)? If so (I think it is because of "poweredge storage"), do you have a dedicated network for your storage and a separate for "LAN" traffic?

Questions: "But if i configure a private Ip in the series of 192.168.1.1 or something like this i am able to browse for internet but can not access internet using public IP's" If you set a PRIVATE IP to your server you can SURF ON INTERNET? And if you set a PUBLIC IP to your server YOU CANNOT SURF, right? " there is no router in between the server" That's quite impossible... if you can surf internet with a PRIVATE address there's something somewhere that gives you a public ip. Are you sure that nobody is using your public IP? Can you provide a network diagram?