June 7, 2010 at 6:45 pm
what is the cause of the sudden and unexpected increase in the load on the sql server?(general reasons)
June 7, 2010 at 8:23 pm
A job has started that requires a lot of CPU
June 7, 2010 at 9:57 pm
Users writing their own queries.
New application added, typically data warehouse and Analysis Services
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
June 9, 2010 at 12:10 am
Server is infected with a virus and you are relaying Viagra spam
June 9, 2010 at 1:15 am
There's no such thing as a "general reason" why the load on your server has increased--you need to do some monitoring to find out what's causing it.
June 9, 2010 at 2:13 am
What made you think on this ???????:discuss:
June 9, 2010 at 2:50 am
Poor engine handling of SQL code (Recursive CTE's).
Someone turned page level locking of on an index.
Someone used explorer to open a folder on the machine where a corrupt file exists.
Someone is using xp_readerrorlog to read error logs (Version dependant)
Someone ran a TSQL query from SSMS, hit the stop button but the query keeps running in the background.
....And that's only been in the last month....
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply