Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cragi
Starting Member
14 Posts |
 Posted - 2008-01-16 : 02:20:05
|
| Show Profile Email Poster Edit Topic Reply with QuoteI have a dedicated SQL Server 2005 Workgroup server with Rackspace (RAID 1, which obviously needs to get changed). It's been running relatively smoothly and the last time I traced it (a couple of weeks ago), there were no significant issues. I run a reindex and I reboot every single night, and have built many indices on the tables using Analysis Services.We move a ton of data in a single day, and the users were complaining of lag, which appeared related to this server. After running a trace, I noticed:- my normal SPs were taking roughly 5-20x the normal duration and many were timing out- I was frequently running SPs directly on the server that gave me transaction deadlocked on resource errors- some of the tiny, quick calls made in the trace were showing as impossible, astronomical durations! Like things that should be "3"ms were showing up as "81544123941234123478090"msIs it corrupted?HELP! |
|
|
cragi
Starting Member
14 Posts |
Posted - 2008-01-16 : 02:31:02
|
| - The installed Service Pack is SP1- The 2 GB memory was showing maxed out, though not sure that matters in 2005- CPU was spiking |
 |
|
|
|
|
|
inconsistent, astronomical duration in trace