Yes it is dedicated box
Just couple of questions: 1. Is there anything at all from SQL Server files perspective that i may safely host on C (OS) drive without compromising...
That's what exactly happens. We have two tables which have 8-20 mil records inserted every day. So i guess hourly index rebuild/reorganize + update...
During the high loads our SQL server eats 80% of our CPU and eventually becomes unresponsive due to completely corrupted query plans The solution was...
Just as a side note: It is very fortunate that we are on enterprise edition and could rebuild indexes Online, if we were not we'd be completely...
For about 4 weeks we were terrorized by CPU flatlining at 70% and making server unresponsive until we either restart SQL service or, believe it or...
:) didn't notice it, will repost
Hello Jethro, Having the same issue, about once a week. Did you ever solve yours, was it a poorly written procedure or config setting?
Separate names with a comma.
