Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OSURDIVAL
Starting Member
2 Posts |
 Posted - 2012-01-04 : 05:31:09
|
| HiWe had a major issue on our production database where multiple blocks started to occur. I killed the main spid that where causing the blocks but this only helped for a while.When I queried a table “select * from XXXX” the query would not run. The table I was querying has 35 lines of data (very small table). If I changed the query to “Select top 11 from XXX” the query ran, when I change the query once again to “Select top 12 from XXX” the query would fail. This was happening on multiple tables.At the end I rebooted the server which sorted the issue. Has anyone seen anything like this before? Any help on the matter will be greatly appreciated.The data file is 47Gbs and log file is 13GBsVersion:Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)There is nothing in the SQL server log file or event viewer |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-04 : 05:52:22
|
| Check the database in case it is corrupted?USE MyDataabseGODBCC CHECKDB WITH NO_INFOMSGS -- , ALL_ERRORMSGS or for a more thorough test:DBCC CHECKDB WITH NO_INFOMSGS, EXTENDED_LOGICAL_CHECKS, DATA_PURITY -- , ALL_ERRORMSGS |
 |
|
|
OSURDIVAL
Starting Member
2 Posts |
Posted - 2012-01-04 : 05:58:58
|
| HiThe DBCC CHECKDB command would not run for me until the server was rebooted. I checked the database after the reboot and it is not corrupted.Cheers |
|
|
|
|
|
|
Database non-responsive issue