Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a Win2008 server 32 bit running as a virtual machine under ESX server. It has 6 CPU cores of 2Gz each and 4GB ram. It's running SQL Server 2008 R2 only.

Problem: the server is heavily loaded and responds slowly. From windows taskmanager's point of view, it really looks overloaded, CPU wise. However, our external "cloud manager" says it's only using 2.5GHz worth of CPU-cycles in the cluster. I/O times looks "good".

We have already tried to set the SQL Servers number of working threads from 0 (auto) to 256, to no effect.

How to tune the VM host, guest or SQL Server to use all of it's aloted resources? Does it sound possible at all?

share|improve this question

migrated from serverfault.com Jun 14 at 18:54

This question came from our site for system and network administrators.

    
Which edition of SQL Server are you running? What is the hypervisor? –  Michael Hampton Jun 13 at 14:28
    
SQL Server 2008 R2. I don't have more details about the hypervisor at the moment. It's vmware. It's a proffessional data center. Do these things differ a lot between versions? –  rocketman Jun 13 at 14:30
1  
"IO times look good". Yeah. Please have that qualified. As in: latency should be below 5ms with small spikes upward. CHeck your stats in sql server (it is not like there is no activity view) to check that yourself. and get some RAM - 6 cores I would not run with less than 12gb. Oh, and voting to close - there is a special website dealing with database administration. Besides the qualification required here (professional, no beginners) and you do not really make that impression ("io looks good I am told"). –  TomTom Jun 13 at 14:33
    
That's the version, not the edition. And I'm not as interested in the hypervisor as in the CPU topology that it's providing to the VM. Coreinfo can show you this. –  Michael Hampton Jun 13 at 14:34
    
Thank you, this was helpful information:) –  rocketman Jun 13 at 14:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.