Browse by Tags

DBCC CHECKDB

Published 14 May 8 5:15 AM | SSQA.net

DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG on the...

Filed under: sql server, dbcc, Database Maintenance

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

Published 26 March 8 3:1 AM | SSQA.net

Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...

Filed under: sql server, performance, blogs, dbcc, disk space, object, file, best practice, monitoring, showcontig, defrag, diskkeeper

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Published 15 November 7 9:41 AM | SSQA.net

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must...

Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads

CHECKDB From Every Angle: How long will CHECKDB take to run?

Published 14 November 7 10:22 PM | SSQA.net

This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out...

Filed under: performance, dbcc, disaster recovery, Database Maintenance, CHECKDB From Every Angle, Corruption

FIX: Error message when you run a query that references a temporary table in SQL Server 2005: "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption"

Published 19 September 7 5:21 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, dbcc, checkdb, kba, error log, buffer pool, internal error

Advice and care you need to follow when you get a solution to your quest on SQL Server forums?

Published 15 September 7 5:56 AM | SSQA.net

Paul Randall has highlighted the importance of DBCC statements you execute within your SQL environment and care you need to take care when you get a solution for your question on the forums & newsgroups. Best advice is to test whatever has been specified...

Filed under: sql server, dbcc, best practices, disaster recovery, sqlskills, advice, paul, randall

Failed to claim unused space with SP_SPACEUSED?

Published 31 August 7 4:9 AM | SSQA.net

Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name...

Filed under: sql server, database, dbcc, dba, space, table, transact sql, data type, delete

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

Published 24 August 7 6:24 AM | SSQA.net

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level...

Filed under: sql server, performance, security, dbcc, index, table, fragmentation, showcontig, defrag

Error: Could not find row in sysindexes for database. 8966, 823 and 602

Published 14 August 7 4:35 AM | SSQA.net

Long ago, not long ago.... No doubt that many of you might have gone through the error above within your SQL environment, also I see many forum posts out there to resolve the issue. The bottom line of this issue is Hardware and no other issue can contribute...

Filed under: sql server, performance, database, dbcc, checkdb, table, hardware, corrupted, sysindexes, 8966, 823, page

How to get updated page or row count information for the current database?

Published 13 August 7 9:0 AM | SSQA.net

DBCC UPDATEUSAGE (0); GO Best practice to use DBCC UPDATEUSAGE i ntermittently and must if you have upgraded the database from SQL 2000 to 2005. The usual working fashion of this DBCC statement is to correct the rows, used pages, reserved pages, leaf...

Filed under: sql server, performance, database, dbcc, updateusage

FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005

Published 22 May 7 12:54 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition KBA - FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated...

Filed under: sql server, dbcc, kba, transaction, index, dbreindex

Database consistency checks and transaction log is filing up, help?

Published 9 May 7 6:40 AM | SqlServer-QA.net (SSQA)

Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are...

Filed under: sql server, performance, transaction log, dbcc, trace, search, concurrency, dba