153 reputation
9
bio website usesmallicons.blogspot.co.uk
location United Kingdom
age 31
visits member for 4 years, 2 months
seen Nov 13 at 21:55

Nov
12
awarded  Popular Question
May
24
awarded  Caucus
Jun
25
answered How I can be alerted if an application is not running in Windows 2008 R2?
Mar
20
awarded  Commentator
Jan
12
awarded  Teacher
Jan
12
answered When to change a workstation name
Jul
3
answered SQL Server 2008 R2 installation/connection questions
Feb
28
revised SQL Server suddenly using only a small portion of CPU
Added final solution to original question
Feb
24
comment SQL Server suddenly using only a small portion of CPU
This problem re-occurred today, turns out you were right. Soon as I turned off SQL Analysis in Spotlight, all our problems went away. Have changed you to answer. Irritating how a tool that is supposed to help you monitor your servers ends up breaking them!
Feb
24
awarded  Scholar
Feb
24
accepted SQL Server suddenly using only a small portion of CPU
Feb
23
awarded  Supporter
Feb
23
awarded  Editor
Feb
23
answered SQL Server suddenly using only a small portion of CPU
Feb
23
revised SQL Server suddenly using only a small portion of CPU
added solution
Feb
23
comment SQL Server suddenly using only a small portion of CPU
I managed to solve the issue by restarting sql server service. However using spotlight has revealed that there are certainly io issues with this server, your comments and advice will help me greatly in fixing this.
Feb
21
awarded  Student
Feb
21
asked SQL Server suddenly using only a small portion of CPU
Oct
13
awarded  Tumbleweed
Oct
6
asked Microsoft Web Farm Framework 502 error