Viewing 15 posts - 31 through 45 (of 62 total)
Just wanted to give an update: All our server team did to resolve this problem was move the SAN to a new "cabinet" and the problem went away. ...
July 9, 2009 at 9:33 am
The problem is gone, but I don't know if the problem is fixed. The reason it's difficult to troubleshoot is that the error only occurs when one of our...
May 30, 2009 at 11:03 pm
Yeah, it's on one of those situation where a lot has happened in a short amount of time...reorg, reloc, lay-offs, new vision, new roles, blah blah. Not making excuses,...
May 29, 2009 at 12:04 pm
GilaMonster (5/28/2009)
I'd be quite willing to bet that the problem will be back next month.
In a way, I hope you are right....even if only in the name of forward-progress.
GilaMonster...
May 28, 2009 at 11:00 am
Well, I'm guessing the problem has been resolved. Unfortunately, none of the recommendations I made were entertained. TempDB is still initialized to something less than 10MB with...
May 28, 2009 at 10:14 am
I didn't think I'd ever see a log file quadruple the size of the data file, especially in less than a 24-hour period. That's what shocked me. I've...
May 27, 2009 at 4:30 pm
The physical server was put back online, the TempDB was 9MB by the time I checked it (not sure what the initialized size was). I ran one of the...
May 27, 2009 at 1:11 pm
GilaMonster (5/26/2009)
Did they say what RAID level? Or are we talking just 2 physical disks with no redundancy of any form?
RAID 5.
BTW: I feel sheepish on this...
May 26, 2009 at 4:33 pm
I talked with our server team and they said that J and P are essentially physical drives on the SAN dedicated to SQL Server (although they may have been keeping...
May 26, 2009 at 3:55 pm
GilaMonster (5/26/2009)
I need...
May 26, 2009 at 2:58 pm
Jeffrey Williams (5/26/2009)
May 26, 2009 at 2:52 pm
GilaMonster (5/26/2009)
All of them? The heavily used and lightly used together?Where's TempDB?
With the exception of MASTER and MODEL, all DB data files, including TempDB, are on one drive (J). ...
May 26, 2009 at 2:26 pm
What's the layout of databases on LUNs?
The MDFs are all on "J". The LDFs are all on "P"...for the most part. There is plenty of space...
May 26, 2009 at 1:53 pm
I checked the timing of the last failed attempt of the job and found the following in the SQL Server Log:
A time-out occurred while waiting for buffer latch -- type...
May 26, 2009 at 1:48 pm
Not sure if this helps, but....
The job history doesn't show anything useful....just a line similar to:
Executed as user: CABLE\!SrvSqlAgent. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights...
May 26, 2009 at 1:33 pm
Viewing 15 posts - 31 through 45 (of 62 total)