CHECKDB Error

I was asked to look at a database that is having serious performance
problems. I ran a DBCC CHECKDB and get a slew of issues. They have been
having the problem for too long to restore/recover. Is there anything I can
do to clear this issue up? I did try to do a repair with data loss and the
problem did not go away.
Thanks.
Richard
Executed as user: NT AUTHORITY\SYSTEM. ...e GAM, but no SGAM or IAM has
allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14040) in database ID
7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
[SQLSTATE 42000] (Error 8905) Extent (1:14352) in database ID 7 is marked
allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE 42000]
(Error 8905) Extent (1:14448) in database ID 7 is marked allocated in the
GAM, but no SGAM or IAM has allocated it. [SQLSTATE 42000] (Error 8905)
Extent (1:14488) in database ID 7 is marked allocated in the GAM, but no
SGAM or IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent
(1:14704) in database ID 7 is marked allocated in the GAM, but no SGAM or
IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15176) in
database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15232) in database ID
7 is marked allocated in the GWhy would you run a CheckDB for performance issues? What are the messages it
is generating?
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:uLEUTFGUHHA.1180@.TK2MSFTNGP05.phx.gbl...
>I was asked to look at a database that is having serious performance
>problems. I ran a DBCC CHECKDB and get a slew of issues. They have
>been having the problem for too long to restore/recover. Is there anything
>I can do to clear this issue up? I did try to do a repair with data loss
>and the problem did not go away.
> Thanks.
> Richard
>
> Executed as user: NT AUTHORITY\SYSTEM. ...e GAM, but no SGAM or IAM has
> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14040) in database
> ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
> [SQLSTATE 42000] (Error 8905) Extent (1:14352) in database ID 7 is marked
> allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE
> 42000] (Error 8905) Extent (1:14448) in database ID 7 is marked allocated
> in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE 42000] (Error
> 8905) Extent (1:14488) in database ID 7 is marked allocated in the GAM,
> but no SGAM or IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent
> (1:14704) in database ID 7 is marked allocated in the GAM, but no SGAM or
> IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15176) in
> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15232) in database
> ID 7 is marked allocated in the G
>|||I ran the check as part of a bigger picture maintenance plan. Reindexing,
purging stale data, etc.
When I run the CHECKDB I get error 8905 over and over.
Is there something I can do to make the database healthy and happy again'
Thanks!
Richard
"ChrisR" <ChrisR@.foo.com> wrote in message
news:OdOQHDHUHHA.920@.TK2MSFTNGP05.phx.gbl...
> Why would you run a CheckDB for performance issues? What are the messages
> it is generating?
>
> "Richard Douglass" <RDouglass@.arisinc.com> wrote in message
> news:uLEUTFGUHHA.1180@.TK2MSFTNGP05.phx.gbl...
>>I was asked to look at a database that is having serious performance
>>problems. I ran a DBCC CHECKDB and get a slew of issues. They have
>>been having the problem for too long to restore/recover. Is there
>>anything I can do to clear this issue up? I did try to do a repair with
>>data loss and the problem did not go away.
>> Thanks.
>> Richard
>>
>> Executed as user: NT AUTHORITY\SYSTEM. ...e GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14040) in database
>> ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
>> [SQLSTATE 42000] (Error 8905) Extent (1:14352) in database ID 7 is
>> marked allocated in the GAM, but no SGAM or IAM has allocated it.
>> [SQLSTATE 42000] (Error 8905) Extent (1:14448) in database ID 7 is
>> marked allocated in the GAM, but no SGAM or IAM has allocated it.
>> [SQLSTATE 42000] (Error 8905) Extent (1:14488) in database ID 7 is marked
>> allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE
>> 42000] (Error 8905) Extent (1:14704) in database ID 7 is marked
>> allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE
>> 42000] (Error 8905) Extent (1:15176) in database ID 7 is marked
>> allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE
>> 42000] (Error 8905) Extent (1:15232) in database ID 7 is marked
>> allocated in the G
>|||Perhaps this applies to you? Not very encouraging, though...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61284
Also, here's some good techninfo, which mentions 8905:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/18/670341.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:e7g4G9HUHHA.2212@.TK2MSFTNGP02.phx.gbl...
>I ran the check as part of a bigger picture maintenance plan. Reindexing, purging stale data, etc.
> When I run the CHECKDB I get error 8905 over and over.
> Is there something I can do to make the database healthy and happy again'
> Thanks!
> Richard
>
> "ChrisR" <ChrisR@.foo.com> wrote in message news:OdOQHDHUHHA.920@.TK2MSFTNGP05.phx.gbl...
>> Why would you run a CheckDB for performance issues? What are the messages it is generating?
>>
>> "Richard Douglass" <RDouglass@.arisinc.com> wrote in message
>> news:uLEUTFGUHHA.1180@.TK2MSFTNGP05.phx.gbl...
>>I was asked to look at a database that is having serious performance problems. I ran a DBCC
>>CHECKDB and get a slew of issues. They have been having the problem for too long to
>>restore/recover. Is there anything I can do to clear this issue up? I did try to do a repair
>>with data loss and the problem did not go away.
>> Thanks.
>> Richard
>>
>> Executed as user: NT AUTHORITY\SYSTEM. ...e GAM, but no SGAM or IAM has allocated it. [SQLSTATE
>> 42000] (Error 8905) Extent (1:14040) in database ID 7 is marked allocated in the GAM, but no
>> SGAM or IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14352) in database ID 7
>> is marked allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE 42000] (Error
>> 8905) Extent (1:14448) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14488) in database ID 7 is marked
>> allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent
>> (1:14704) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
>> [SQLSTATE 42000] (Error 8905) Extent (1:15176) in database ID 7 is marked allocated in the GAM,
>> but no SGAM or IAM has allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15232) in database
>> ID 7 is marked allocated in the G
>>
>|||Can you email me the complete output from CHECKDB? (Send me email through my
blog below)
--
Paul Randal
Principal Lead Program Manager
Core Storage Engine, Microsoft SQL Server Team
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e472SBIUHHA.4744@.TK2MSFTNGP02.phx.gbl...
> Perhaps this applies to you? Not very encouraging, though...
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61284
> Also, here's some good techninfo, which mentions 8905:
> http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/18/670341.aspx
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Richard Douglass" <RDouglass@.arisinc.com> wrote in message
> news:e7g4G9HUHHA.2212@.TK2MSFTNGP02.phx.gbl...
>>I ran the check as part of a bigger picture maintenance plan. Reindexing,
>>purging stale data, etc.
>> When I run the CHECKDB I get error 8905 over and over.
>> Is there something I can do to make the database healthy and happy
>> again'
>> Thanks!
>> Richard
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:OdOQHDHUHHA.920@.TK2MSFTNGP05.phx.gbl...
>> Why would you run a CheckDB for performance issues? What are the
>> messages it is generating?
>>
>> "Richard Douglass" <RDouglass@.arisinc.com> wrote in message
>> news:uLEUTFGUHHA.1180@.TK2MSFTNGP05.phx.gbl...
>>I was asked to look at a database that is having serious performance
>>problems. I ran a DBCC CHECKDB and get a slew of issues. They have
>>been having the problem for too long to restore/recover. Is there
>>anything I can do to clear this issue up? I did try to do a repair with
>>data loss and the problem did not go away.
>> Thanks.
>> Richard
>>
>> Executed as user: NT AUTHORITY\SYSTEM. ...e GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14040) in
>> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14352) in
>> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14448) in
>> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14488) in
>> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:14704) in
>> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15176) in
>> database ID 7 is marked allocated in the GAM, but no SGAM or IAM has
>> allocated it. [SQLSTATE 42000] (Error 8905) Extent (1:15232) in
>> database ID 7 is marked allocated in the G
>>
>>
>