troubleshooting Question

SQL Server Speed

Avatar of ComexIT
ComexIT asked on
Microsoft SQL Server 2008Microsoft SQL ServerDatabases
9 Comments1 Solution252 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
gmartinnc
Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros