August 8, 2008 at 10:45 am
Hi All
I recently migrated all my production servers to SAN on Virtual machines,( this is debate going on wether to do it or not), it worked perfectly fine for the last 3 weeks, this week started with a nightmare, one of my database machine seems to be using all its CPU, and i cant do any anything on server, every applicaiton loses its connection to that database machines, i cant figure out what is happening, i used profiler to get whats going on but i cant find out anything that is important, i even stopped some jobs on that machine, that dint help as well. Finally i archived one big table, that made a difference ann then i did update SP2 to all the machines, but now for the last 2 days the systems seems to be stable, but when i access data from linked server it uses lots of resources (CPU), and sometimes it blocks as well.
My doubt, i had the same rows on that table before migration. did SP2 helped on this?? do is there any thing that i can do to get back my old SAN Performance?? 🙂
I am using SQL 2005 (64 bit) on Windows 2003
Thanks for all your posts in advance 🙂
August 8, 2008 at 11:44 am
CrazyMan (8/8/2008)
Hi AllI recently migrated all my production servers to SAN on Virtual machines,( this is debate going on wether to do it or not), it worked perfectly fine for the last 3 weeks, this week started with a nightmare, one of my database machine seems to be using all its CPU, and i cant do any anything on server, every applicaiton loses its connection to that database machines, i cant figure out what is happening, i used profiler to get whats going on but i cant find out anything that is important, i even stopped some jobs on that machine, that dint help as well. Finally i archived one big table, that made a difference ann then i did update SP2 to all the machines, but now for the last 2 days the systems seems to be stable, but when i access data from linked server it uses lots of resources (CPU), and sometimes it blocks as well.
My doubt, i had the same rows on that table before migration. did SP2 helped on this?? do is there any thing that i can do to get back my old SAN Performance?? 🙂
I am using SQL 2005 (64 bit) on Windows 2003
Thanks for all your posts in advance 🙂
Do you have multiple SQL instances on the same virtual server or one SQL instance per virtual server? We played with virtual servers (on blades)/SAN with SQL 2005 and came to the conclusion that it wasn't a good idea for a production SQL Server environment. We have separate servers for our 2005 prod cluster that store the data files on the SAN. Our dev environments are virtual servers. The reason I ask about the multiple instances is because virtual servers do not seem to handle that very well. Also, it is very import to set max memory for SQL server so it doesn't starve the OS. Seems to be even more of an issue when it is virtual. The other thing I would suggest is going to cumulative update 7 (9.0.3239) for SQL Server, if you aren't there already. When we upgraded to SP2, we saw a lot more performance issues until we installed CU7. Hope this helps.
August 9, 2008 at 12:44 am
Thaks Hill, i have one instance per server, and i have set a max memory as well, its releatively small machine, its having 6 GB RAM, out of which 5 is allocated to SQL (Max Memory). 🙂
I will upgrade CU for 2005.
Thanks:)
August 10, 2008 at 5:14 pm
Can you list out which VMs you have and their allocations? What is the size of your physical machine?
There are issues with IOs especially with VMs. There is overhead and issues with IO can cause problems with CPU as well.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply