1,341 reputation
21128
bio website
location Edmonton, Canada
age 29
visits member for 4 years, 11 months
seen Feb 13 at 16:47

I work as a DBA and a backup LAN admin focusing on Windows technologies


Oct
24
awarded  Famous Question
May
29
awarded  Yearling
Apr
23
awarded  Popular Question
Apr
11
awarded  Popular Question
Mar
20
awarded  Famous Question
Jun
28
awarded  Notable Question
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
29
awarded  Yearling
Apr
12
awarded  Notable Question
Feb
14
awarded  Popular Question
Nov
18
awarded  Analytical
Oct
26
awarded  Popular Question
Jul
25
awarded  Popular Question
Jul
20
awarded  Popular Question
Jun
30
comment SQL2005 Stuck in Single Mode User
I agree with this. Somehow you lost your single connection and something else obtained it. If any web apps or anything at all accesses the SQL Server it will have locked you out. Restart the SQL service or at worst the server itself.
May
30
awarded  Yearling
May
17
comment Max and Min Memory Setting
That's correct. There's no load balancing in a SQL cluster outside of manually setting up what runs on each node.
May
13
comment Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?
I think it belongs here. It's most likely an administrator who should notice performance problems on the production servers. Follow up questions on how to fix any problems caused by bad T-SQL/.NET code would belong on SO.
May
13
comment Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?
Unfortunately no. I don't maintain any web servers so I'm not too familiar with them.