We help IT Professionals succeed at work.

SQL Server Speed

249 Views
Last Modified: 2015-01-22
Hi,

We have a SQL Server 2008 r2 Running on a VM Ware platform with 18gb Ram Assigned on Windows 2008 r2, 4 Cores assigned to VM.

Users are reporting that when they use software that connect to server it seems to run very slow, looking on processors they are never above 50 % and there is 2gb of Ram free.

Has anyone got any suggestions of where to check to make sure the SQL side is running at full steam, not a SQL expert so any help would be great,

Thanks
Comment
Watch Question

Ryan McCauleySenior Data Architect
CERTIFIED EXPERT

Commented:
The processors aren't at 100% and there's RAM free, but how are the disks? I'd check to make sure the latency is low and throughput is good - I've run into a number of cases (especially on VMs) where storage is slow and it's not always obvious. Do you notice latency when you connect to the server's desktop and attempt to perform normal operations (like browsing folders)? Are there multiple physical drives in the server (or connected to the server) and is SQL spread effectively across storage?

When you're dealing with a VM, all storage aside from dedicated storage inside the host mapped directly to the VM is remote shared storage, so ensure that it's able to access it without any issues.
Dave BaldwinFixer of Problems
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
"Speed" of the SQL Server also depends on the queries that they are running.  If they are using a lot of joins in a complicated query that can't use indexes, that can be slow all by itself.

Author

Commented:
Hi,

Its connected to a Dell Equalogix box which is quick, when i do anything on desktop its quick via RDP, no delays at all.

J

Author

Commented:
Just one thing i noticed, when i clicked on properties it shows memory as set to 8gb ..... should this be set to more ?
CERTIFIED EXPERT
Top Expert 2012

Commented:
looking on processors they are never above 50 % and there is 2gb of Ram free.
How do you know that?  If the answer is "I looked at Task Manager" then that is not the whole story:   TM is only showing what VMWare is feeding it.

But as indicated previously your or your DBA or your vendor need to start analyzing what is the query that is making it feel slow.  Caution the root cause may not be the same as the one the user is complaining about.
Ryan McCauleySenior Data Architect
CERTIFIED EXPERT

Commented:
If you're using a VM, keep in mind that what you see in your resource indicators inside the VM is only part of the story as well - you'll need to ensure that RAM, processor, and all the other resources at the physical host level are also in good shape. Even if the VM is only using 50% if its assigned processor, that doesn't meant that the physical host doesn't contain 50 VMs that are all pegging the host processor as a whole.
CERTIFIED EXPERT
Top Expert 2012

Commented:
If you're using a VM, keep in mind that what you see in your resource indicators inside the VM is only part of the story as well
Exactly.
Database Architect
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2012

Commented:
I think the author is MIA.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions