SQL Server running slow

Question

Post reply

SQL Server running slow

aksh.2411

Right there with Babe

Points: 762
More actions
August 2, 2011 at 9:46 am

#390106

Hi,
I am having SQL Server 2008 standard edition.having 16 GB of ram.Currently CPU utilization is 100% & memory is alomst utilised.
I have seen that i/o is very high.Currently 8 GB of ram is allocated to SQL Server.what to do in such scenarios??
Thanks,
Aksh

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

aksh.2411 Right there with Babe Points: 762 More actions · Answer 2

Hi Gail,

Thanks for your reply.I will go through it.In case of any query i will get back to you.

Thanks,

Akshay

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

If you don't get everything you need from Gail's excellent articles, you might want to pick up a copy of my book on query tuning. It might help.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning