abitguru

hope this helps, I not really into performance monitor :( Disk. copy a large file (~ 2GB)

my mistake. And my mistake forgot say this change we do last weekend, every disk has a direct connection to storage. I'll try to find NETWORK STORAGE AND LAN in perform (only find Network Interface) and post results. thanks

All interfaces (supposedly) have an direct connection to an Iscsi disk. 192.168 (STORAGE LAN) 10.95 (SERVER and uses lan) EXCEPT First Connection (the one with 16GB). This connection has another IP (other lan) All interfaces except Citrix PV Ethernet Adapter has an 192.168 IP But Citrix PV Ethernet Adapter has an 10.95 IP, 10.95 is the users lan When we make a SQL query the traffics goes for Citrix PV Ethernet Adapter_4 (192.168) When we make a DBF query or process the traffics goes for Citrix PV Ethernet Adapter (10.95) So the dbf traffics goes for users lan. If you want to see a pic of this please ask and i will upload I see that this could be the problem, because we have problems with dbf process (too long). IF traffic goes for users lan, and not for storage. Another test: 5 am run a process took 4 secs 9 am the same process took 30 secs Only diference is the users connected. Thans again!!!

about 5 minutes (and we generate a little traffic :) )

Here is a pic of Performance Monitor The only problem is in spanish :( http://img100.imageshack.us/img100/7265/datosg.png

Nod32 is active in the server and in every PC. It has Network disk active to scan (in every pc), but they say us that this is no problem because only scans when a file is open. There isnt a process scanning the network, but we will disable this option and test. I dont know how NOD32 works, so we will test this too. Thanks!!!

yes rigth, we have two separeted lans when we make the server change, we asign a network connection for each disk (1 for windows, 1 for sql data, 1 for log, 1 for tmpdb, 1 for system file(dbf) ) I will see if i can find what you say in performance monitor. thanks a lot.

Sorry to be soooo noob, but i cant find in performance monitor any counter with NETWORK STORAGE AND LAN. I have network interface MSAS 2008: XXXXX You mean log a specific counter or I misunderstod?

We not experiment much timeouts because we have a lot of RAM assgned to SQL, and this compense. (I think) ~ 12MB/s Copy. Reading cound be better but not to much. I will use the counter you say and post the results. About the second point (i dont have access to storage tools, and at this point i think the admin dont know if this exists) The point you mencioned in point 2 is what we want, prove that is a problem of the storage and SQL or Windows has nothing,

Tested this simple way. lask weekend we reinstall ALL, Windows Server 2008 R2 SQL Server. 1 - Transfering Backup (80 GB) From old server to new Server. ~ 12 MB/s No uses conected, Old Server restarted No Lan Traffic ~ 12 Mb/s for me its a joke. 2 - Test 2. Today, early in the morning we test a process (run on old legacy system in fox pro 2.6 with dbfs) Results. The process finish in less than 10 seconds. Test the same process at 8:00 am, with most users connected took ~ 45 sec This makes me think there are a bottleneck somewhere. Other test we will do at noon is, ask for users to close the system and test again same process and see if there changes. Thanks a lot.!

Thanks so much!! We make some tests and realise that the problem with performance is not the ram, is not SQL. We make a simple process with a few users using the system, and the process take less than 10 seconds, now with more users the same process took 30 ~ 45 seconds. I supouse there is a RAM problem, but with this test I can say there is no RAM problem. I'm close to say the storage has the problem, but I cant prove it. (and the it guy don't do anything to test for his own) Thanks for your help again! :D :D

What do you mean with fixed? http://imageshack.us/photo/my-images/138/imgih.png/ Now is set to automaticaly set the size of page file. If you see previos 2 images, that is the situation, SQL consuming 21 GB (its ok) but we have 37 MB free in first image, and ~ 900 in second image.

Yes I think we have a long way to see and discover what really happend. (We cant make magic with our systems if we have poor performance) I think we have severals points to check and correct. Thanks again!

Right now Windows Server config is: Page File Size 32762 MB Minimun 16 MB Recomended 49143 MB http://imageshack.us.../pagefilec.png/ http://imageshack.us/photo/my-images/52/hardmonitor.png/

I'll post an image on my profile (waiting for 20 posts :) ) thanks!

Thanks ITC, I see on task manager.. SQL Server is using ~ 20 GB, but the strange thing is that no other process is using much memory. I try process explorer and resources monitor of Windows Server, and i can't figure out witch process is taking the memory. I'll check the page file size.

another thing to comment is that using RAMMap the values are Process Private ~ 21.000.000 K (SQL Server) Mapped File ~ 9.000.000 K ( ?????? ) Unused ~ 790.00 K What is Mapped File?? I suspect that is the problem.

Hi, I'm not very into Windows Server Functionality.. so I have to ask if this behavior is normal or not. There is the thing. We have a Virtual Windows Server 2008 R2 with 32 GB of Ram 20 GB for SQL 12 GB for SO In the server. SQL Server 2008 Some DBF Tables (not larger than 500MB) We noticed after restar that SQL grows up till 20 GB.. this is ok we set this option in SQL After some time.. lets say une day. we see the SO is out of memory. In Task Manager we see "Free Memory" < 50MB and in cached Memory we see all the memory for the SO. 1 - The question is.. is this normal in Windows Server 2008 (and R2) ? I see a lot of people asking for this.. 2 - If Windows says "there is no memory", he start swapping? 3 - Is there any way to see how is taking the memory of the SO. I try a workaround (not a hotfix) but i'm not sure if this is my problem (Hi, I'm not very into Windows Server Functionality.. so I have to ask if this behavior is normal or not. There is the thing. We have a Virtual Windows Server 2008 R2 with 32 GB of Ram 20 GB for SQL 12 GB for SO In the server. SQL Server 2008 Some DBF Tables (not larger than 500MB) We noticed after restar that SQL grows up till 20 GB.. this is ok we set this option in SQL After some time.. lets say une day. we see the SO is out of memory. In Task Manager we see "Free Memory" < 50MB and in cached Memory we see all the memory for the SO. 1 - The question is.. is this normal in Windows Server 2008 (and R2) ? I see a lot of people asking for this.. 2 - If Windows says "there is no memory", he start swapping? 3 - Is there any way to see how is taking the memory of the SO? I try a workaround (not a hotfix) but i'm not sure if this is my problem (Installing and using the Microsoft Dynamic Cache Service) Extra info about memory.. Total 32762 Cached 9543 Free 983 Available 10526 4 - The memory Cached, can be used by the SO? Available is Cached + Free.. but in Windows Server 2008 (not R2) there is no Available. Thanks so much for your commets.. (keep in mind i'm a soft developer, so Windows Admin is not my forte)

ICT, we reinstall all, the performance improve a little. Yes the it people explain us that we have a one big disk. Now I have another question but i ll open another thread Thanks so much for your valuable help!!!

we are reinstalling the server using windows 2008 r2. the it people will reorganice the storage space and asign disk per servers, (don't know very much the change but will fix most of our performance problems ) Thanks for your help ICT!!!

I post another pic, the thing I noticed is the disk is never higher than 100Mb/s, sometimes lower than 10mb/s Are these normal numbers or I'm misinterpret something. Thanks a lot.

I've more info about the storage.. I'll try disable real time scan. thanks a lot!! EqualLogic PS6000X iSCSI SAN Storage

Thanks ICT, i can't disable SQL because its a production server. I cant disable nod32 because it managed by other department, i'll ask for that. Now I put a pic with a very larga SQL statement, hope this helps!! Thanks

sorry for the trick, but i cant find how to send PMs, don't know if its permision or what, but if you enter in my profile I put the image on Skype info. Sorry for doing this way but I cant find other (i think is because i'm newbie) thanks. (let me know if you see the pic)

I've a screen but i dont know how to post it here besause i dont have 20 post already.