[newbie] dbcc showcontig

Hello.

Can you point me to books or good documentation that could help me in
understanding in detail the dbcc showcontig output (and the output of
other command that analize the status of a DB) and permit me
understanding what is going on and taking appropriate action?

Do you think a Microsoft Courses could help in this, or is it necessary
to just study/work to become good in this? If it can be useful, which
Microsoft courses?

Best Regards,
Mamo<mamo74@.gmail.com> wrote in message
news:1106796688.136298.283920@.z14g2000cwz.googlegr oups.com...
> Hello.
> Can you point me to books or good documentation that could help me in
> understanding in detail the dbcc showcontig output (and the output of
> other command that analize the status of a DB) and permit me
> understanding what is going on and taking appropriate action?
> Do you think a Microsoft Courses could help in this, or is it necessary
> to just study/work to become good in this? If it can be useful, which
> Microsoft courses?
> Best Regards,
> Mamo

http://www.sql-server-performance.c..._showcontig.asp

Simon|||This is a good guide but leaves out a huge amount of relevant information
(most significantly a discussion of logical fragmentation, DBCC INDEXDEFRAG
and the effects of multiple files on the DBCC SHOWCONTIG algorithms). You
should also read our whitepaper on the subject (it also deals with when you
should bother to reduce fragmentation).

http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx

Regards

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:41f8cfb0_2@.news.bluewin.ch...
> <mamo74@.gmail.com> wrote in message
> news:1106796688.136298.283920@.z14g2000cwz.googlegr oups.com...
> > Hello.
> > Can you point me to books or good documentation that could help me in
> > understanding in detail the dbcc showcontig output (and the output of
> > other command that analize the status of a DB) and permit me
> > understanding what is going on and taking appropriate action?
> > Do you think a Microsoft Courses could help in this, or is it necessary
> > to just study/work to become good in this? If it can be useful, which
> > Microsoft courses?
> > Best Regards,
> > Mamo
> http://www.sql-server-performance.c..._showcontig.asp
> Simon

[Microsoft] [ODBC SQL Server Driver] Timeout expired

Hi, Everyone,

I have a SQL 2000 cluster with sp4. I used SQL QUERY Analyzer to running DBCC CHECKDB for 2 of user’s databases (one is 110 GB and other 5 GB) and get the following message: [Microsoft] [ODBC SQL Server Driver] Timeout expired.I am running same DBCC CHECKDB against system databases or other small users’ databases are fine.

I can get resulted back from T-SQL (DBCC CHECKDB) against these 2 user databases and I checked sp_configure with other server, I can not find the difference.

Can someone help me out?

KT

Are you executing CHECKDB against 2 of those databases at the same time?

Also check event viewer and SQL error logs for any sort of slow performance with any of the hardware or components on this server.

Have you tried scheduling the same using a SQLagent job?

Have you applied or tested the sp4 hotfix?

|||

I ran dbcc checkdb agaist each database at each time. There has no information logon at even view and SQL log when I got time out message.

I haven't schedule this dbcc checkdb at SQL agent job yet.

I only applied hot fix -KB903086 and brought SQL server level to v8.00 2140.

|||ODBC Sql server drive Timeout expires error message getting when I connect to sql200 server data base with query analyzer

[Microsoft] [ODBC SQL Server Driver] Timeout expired

Hi, Everyone,

I have a SQL 2000 cluster with sp4. I used SQL QUERY Analyzer to running DBCC CHECKDB for 2 of user’s databases (one is 110 GB and other 5 GB) and get the following message: [Microsoft] [ODBC SQL Server Driver] Timeout expired.I am running same DBCC CHECKDB against system databases or other small users’ databases are fine.

I can get resulted back from T-SQL (DBCC CHECKDB) against these 2 user databases and I checked sp_configure with other server, I can not find the difference.

Can someone help me out?

KT

Are you executing CHECKDB against 2 of those databases at the same time?

Also check event viewer and SQL error logs for any sort of slow performance with any of the hardware or components on this server.

Have you tried scheduling the same using a SQLagent job?

Have you applied or tested the sp4 hotfix?

|||

I ran dbcc checkdb agaist each database at each time. There has no information logon at even view and SQL log when I got time out message.

I haven't schedule this dbcc checkdb at SQL agent job yet.

I only applied hot fix -KB903086 and brought SQL server level to v8.00 2140.

|||ODBC Sql server drive Timeout expires error message getting when I connect to sql200 server data base with query analyzer

[BEA][SQLServer JDBC Driver][SQLServer]Warning:Fatal error 605 occurred

Dear group
The following error occured
[BEA][SQLServer JDBC Driver][SQLServer]Warning:Fatal error 605 occurred
and after using DBCC was rectified, but we are not sure the cause of
this problem.
Is it due to SAN installed last month or is there any other reason.
KaranError 605
Severity Level 21
Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object
'%.*ls', not to object '%.*ls'.
You have corruption in your DB.
Look at http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Karan Lobana" wrote:
>
> Dear group
> The following error occured
> [BEA][SQLServer JDBC Driver][SQLServer]Warning:Fatal error 605 occurred
> and after using DBCC was rectified, but we are not sure the cause of
> this problem.
> Is it due to SAN installed last month or is there any other reason.
>
> Karan
>