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 databas
e 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 mark
ed
allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE 420
00]
(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 databas
e 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 datab
ase
> 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 ma
rked
> 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] (Err
or
> 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) Ex
tent
> (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 datab
ase
> 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...
>|||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/sqlserverstor.../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@.TK2MSFTNGP
05.phx.gbl...
>|||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/sqlserverstor...ne/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/sqlserverstor...ver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Richard Douglass" <RDouglass@.arisinc.com> wrote in message
> news:e7g4G9HUHHA.2212@.TK2MSFTNGP02.phx.gbl...
>