|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL 2000 Database corruptMy server contains severals databases.
All query returns a response. But performance are very low when my query "links" 2 databases with a "inner join". So I create a new base, copied data on this base and all is all right. Is there any tool to determine if the database is corrupt ? I've tried DBCC CHECKDB, but it's doesn't detect any error. Thanks. Another thing to look at are indexes and statistics on your other database.
If statistics are out of date or if you don't have the appropriate indexes on your tables performance can suffer. -- Show quoteKeith Kratochvil "Laurent" <esti***@antibia.com> wrote in message news:e0AamuktGHA.4848@TK2MSFTNGP02.phx.gbl... > My server contains severals databases. > All query returns a response. > But performance are very low when my query "links" 2 databases with a > "inner join". > > So I create a new base, copied data on this base and all is all right. > > Is there any tool to determine if the database is corrupt ? > I've tried DBCC CHECKDB, but it's doesn't detect any error. > > Thanks. > Laurent (esti***@antibia.com) writes:
> My server contains severals databases. There is no reason to believe from what you have related that any of> All query returns a response. > But performance are very low when my query "links" 2 databases with a > "inner join". > > So I create a new base, copied data on this base and all is all right. > > Is there any tool to determine if the database is corrupt ? > I've tried DBCC CHECKDB, but it's doesn't detect any error. the databases are corrupt. More likely the issue is one (or both off): o Statistics out of date. Run UPDATE STATISTICS on the involved tables. o Serious fragementation. Run DBCC SHOWCONTIG to determine the current status. DBCC DBREINDEX to defragment. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Show quote
"Erland Sommarskog" wrote: I dont sink so.> Laurent (esti***@antibia.com) writes: > > My server contains severals databases. > > All query returns a response. > > But performance are very low when my query "links" 2 databases with a > > "inner join". > > > > So I create a new base, copied data on this base and all is all right. > > > > Is there any tool to determine if the database is corrupt ? > > I've tried DBCC CHECKDB, but it's doesn't detect any error. > > There is no reason to believe from what you have related that any of > the databases are corrupt. > > More likely the issue is one (or both off): > > o Statistics out of date. Run UPDATE STATISTICS on the involved tables. > o Serious fragementation. Run DBCC SHOWCONTIG to determine the current > status. DBCC DBREINDEX to defragment. > > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > maybe its autentifikation problem while logining... try create enoter linked server with different logining... My databases are on the same server.
I'm logged as sa (system administrator). I've tried UPDATE STATISTICS and DBCC DBREINDEX but it doesn't change anything on my server. Thanks. "GavrishDV" <Gavris***@discussions.microsoft.com> a écrit dans le message de news: 994BDD1F-813D-4CA7-9ACA-8375195F3***@microsoft.com...Show quote > > > "Erland Sommarskog" wrote: > >> Laurent (esti***@antibia.com) writes: >> > My server contains severals databases. >> > All query returns a response. >> > But performance are very low when my query "links" 2 databases with a >> > "inner join". >> > >> > So I create a new base, copied data on this base and all is all right. >> > >> > Is there any tool to determine if the database is corrupt ? >> > I've tried DBCC CHECKDB, but it's doesn't detect any error. >> >> There is no reason to believe from what you have related that any of >> the databases are corrupt. >> >> More likely the issue is one (or both off): >> >> o Statistics out of date. Run UPDATE STATISTICS on the involved tables. >> o Serious fragementation. Run DBCC SHOWCONTIG to determine the current >> status. DBCC DBREINDEX to defragment. >> >> >> >> -- >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> Books Online for SQL Server 2005 at >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx >> Books Online for SQL Server 2000 at >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> > > I dont sink so. > maybe its autentifikation problem while logining... > try create enoter linked server with different logining... Laurent (esti***@antibia.com) writes:
> My databases are on the same server. Unfortunately without knowing any details of your queries and databases> I'm logged as sa (system administrator). > > I've tried UPDATE STATISTICS and DBCC DBREINDEX but it doesn't change > anything on my server. it's difficult to assist further. If I understand it correctly, you had two tables in two databases, and ran a query against these tables with poor performance. The you copied the data into one database and got better performance. But it's not clear if the tables in the two scenarios are identical. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics