Viewing 15 posts - 31 through 45 (of 130 total)
We have a DR server for log shipping sitting dormant aside from restores. It's another dedicated box that used to be our production server 4 years ago. When my company...
September 13, 2012 at 11:44 am
The box is a dedicated machine and other processes are checked with no variance seen on the box when the problem occurs. The box has 36 GB of mem total...
September 13, 2012 at 11:31 am
Some times but not all when the freeze occurs, there are the two message multiple times in the SQL Agent Log:
[382] Logon to server 'MANNASQL2' failed (ConnAttemptCachableOp)
[165] ODBC Error: 0,...
September 13, 2012 at 11:21 am
Not every time but a couple times this morning I have captured a small group (10-15) of ATTENTION events in Profiler AFTER these freezes are over. I very seldom otherwise...
September 13, 2012 at 11:17 am
At 9 am, I could run sp_who2 and get query results. CPU was at 40ish percent and nothing I don't see often when no blocking was occurring (file attached)
At 9:30...
September 13, 2012 at 8:53 am
Auto Close is false on all system and users databases.
September 12, 2012 at 3:23 pm
Dang, happened again one month later after weeks of success. Unfortunately, from what I learned last time I spent time investigating; I really have no control to get any files...
July 9, 2012 at 10:21 am
If the dbcc command is still going you can call a command of
sp_who2 active
in SSMS to see some connection information.
Otherwise, some DBCC commands get logged in the SQL server...
June 23, 2012 at 4:20 pm
I lost the fought on the maintenance window from business and waited until the weekly production check. Everything is good, no errors recurring after the weekend audits. Thanks!
June 23, 2012 at 4:13 pm
oops sorry, wrong link... 2005:
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.90).aspx
June 14, 2012 at 10:15 am
2,3 and 4: A lot, really big, and a lot... but number 1: be careful with licensing breach.
June 14, 2012 at 10:14 am
Are running any reconfigure commands, either?
June 11, 2012 at 4:09 pm
If you are worried about memory being cleared out, you could look for signs of memory being paged out in the SQL server log. You might also be able to...
June 11, 2012 at 4:08 pm
You still want to keep the maintenance plan but not the job associated? What is the overall goal?
June 11, 2012 at 1:37 pm
Viewing 15 posts - 31 through 45 (of 130 total)