|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 3:47 PM
Points: 1,524,
Visits: 1,199
|
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 09, 2010 9:28 AM
Points: 13,
Visits: 39
|
|
No problem.
Do you have anymore ideas on what I can do to further troubleshoot this issue?
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, March 09, 2010 1:32 PM
Points: 164,
Visits: 250
|
|
DO you see any error messages in sql errorlog (not exact but something similar)
spid73 A time-out occurred while waiting for buffer latch -- type 4, bp 00000000B3FE1180, page 1:2554, stat 0x2c0010b, database id: 10, allocation unit Id: 72057594045530112, task 0x0000000003E7AB08 : 0, waittime 300, flags 0x2000000021, owning task 0x00000000046905C8. Not continuing to wait.
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 12:13 PM
Points: 16,988,
Visits: 12,113
|
|
Paul Randal (5/10/2009)
[Edit: thought I deleted this post right after I posted it]
Delete doesn't do anything anymore. Couple issues with people posting insults and then deleting the posts after others replied harshly.
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 09, 2010 9:28 AM
Points: 13,
Visits: 39
|
|
I didn't see anything like that in the SQL Error Log. The Check DB started at about 10:00 PM last night, and all I say in the error log were a bunch of Log Shipping informational messages, and the DBCC CheckDB results for the smaller DBs. At 6:00 AM the next day I saw the below error message...
Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576
Which was followed by a bunch or memory clerk, cache store, user store, object store, etc... messages.
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 3:47 PM
Points: 1,524,
Visits: 1,199
|
|
ok - best bet is to call Product Support to help work out what's wrong - we're not going to be able to do it over the forums. Let us know what you find out.
Thanks
Paul Randal
CEO, SQLskills.com - Need a database maintenance/ops/HA/DR audit? Send me email!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine and SQL Server Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 09, 2010 9:28 AM
Points: 13,
Visits: 39
|
|
| I will do that today. I will let you know what they come up with.
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 9:54 AM
Points: 505,
Visits: 1,126
|
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 09, 2010 9:28 AM
Points: 13,
Visits: 39
|
|
| Ok, so I opened a ticket with Microsoft on the issue. We used the web support system, so updates are not so fast. They asked me to run the typical PSSDiag while the SQL MAINT -chkDB is running, and to send the application/system event logs. I am in the process of doing that now. Just wanted to give everyone update incase you thought I forgot :)
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, March 09, 2010 1:32 PM
Points: 164,
Visits: 250
|
|
| can you send the errorlogs. i can have a look and give you any suggestions .
|
|
|
|
