Posts
Sort by recent activity
missing column statistics
One of our servers seems to be burning extra cpu and when I have examined the default trace in profiler i see the following info:
NO STATS:([tempdb].[dbo].[##redgate_sqlmonitor_querywaitstats_serve...
SQBCoreservice consuming 80 - 90% cpu
Hello - i did post this ealier but i think it went into the wrong section of the web site so apologies if your re-reading this/.
We use backup 7 to do nightly backups (1am) and we backup the transa...
SQBCoreservice consuming 80 - 90% cpu
I need help troublshooting as to why whenever we get a 100% processor utilization using sql monitor the culprit is always SQBCoreservice consuming 80% - 90% processor usage.
There are no conflictin...
cpu usage 90% for an hour
I had a support call at 1pm saying that users where saying the app was running slow. I checked the cpu processor time and it was pegged up at around 90% for over an hour.
I have used the back in ti...
sql monitor alert level not changing down a level
I have the alert "Increased % of fragmented indexes" set up on sql monitor. The medium level alert is set when the value reaches 25 and the alert was fired at value 29. I last night ran some index ...
large object in buffer cache
"LARGE OBJECT IN BUFFER CACHE"
Can anybody advise me on the action to take when i see this alert in sql monitor.
We have it set at the default values and I am wondering on the best techniques to re...