January 25, 2011 at 8:28 am
I have an SQL Server 2005 64 bit installation running in Windows 2008 R2 Enterprise. The performance of the server degrades significantly over time. Applications become nearly unresponsive. On the SQL Server itself even opening the Activity Monitor in the Management Studio is very slow and at times won't even open. Windows is running on a Dell PowerEdge R710 server with 48 GB of RAM databases are stored on an Equallogic SAN. Performance of the disks and memory seems to be minimal from all counters that I've run.
Benjamin Bellamy
January 25, 2011 at 8:43 am
Sounds like either the CPU or RAM is overutilized, based on the fact that SSMS takes a long time to open. What are the wait stats on those? How about the utilization?
I'm assuming you've started with Perf Mon. Correct?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 25, 2011 at 8:46 am
That was my first thought as well. CPU utilization is less than 20% most of the time. Of the 48GB of RAM 24 is currently being used.
January 25, 2011 at 9:28 am
If you're not seeing CPU or Disk issues, I'd start looking for weird stuff. Do you have lots of connections unclosed? Are there uncommitted transactions? Stuff like that. Something that would go away on a reboot, but come back over time.
"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
January 26, 2011 at 7:10 am
Does SQL Server have a maximum RAM setting that's too low for the server? Is it set up correctly for 64-bit operation?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 26, 2011 at 9:56 am
SQL is set to use 20GB of available RAM with the total server RAM being 48GB. SQL target memory never exceeds the available memory configured. This server was functioning normally until Sunday. All perfmon counters seem to indicate that the server is not under any stress at all. I don't think I understand the question regarding being set up properly for 64 bit. It was set up in a 64 bit version of Windows using a 64 bit version of SQL 2005.
January 26, 2011 at 10:20 am
What all is running on the server? Any processes outside of SQL Server? Are you using CLR and/or SSIS or any of the other tools / apps? Have you looked at open/uncommited transactions as listed above?
January 26, 2011 at 12:14 pm
If it was running good until Sunday, what changed on Sunday? New code release, service pack, new client, new users? Something had to have happened to it.
"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
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply