Browse by Tags

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

SQL Server 2005 Partitioned Tables and Indexes - learning curve

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

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

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: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005

Published 11 August 7 5:15 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: The performance of insert operations against a table that contains an identity column...

Filed under: sql server, performance, database, kba, insert

SQL Server 2005 unable to shrink the transaction log, help? (peculiar issue)

Published 15 June 7 5:19 PM | SSQA.net

On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located...

Filed under: sql server, performance, database, transaction log, kba, article, shrink

SQL Server 2005- Is it possible to schedule Data Tuning Advisor?

Published 15 June 7 8:32 AM | SSQA.net

I came across interesting post in SSP looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of SQLServer Agent. As the originator looking to schedule it on a regular basis to scan a trace (Profiler) file and...

Filed under: sql server, profiler, performance, tuning, database, dta

Snapshot backups - do I need equivalent database size disk space?

Published 23 May 7 3:17 AM | SSQA.net

Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of...

Filed under: sql server, performance, backup, database, disk, space, snapshot

SQL Server 2005 & 2000 - Index optimization best practices

Published 22 May 7 1:31 PM | ssqa

In SQL Server 2000 for index defragmentation DBCC DBREINDEX and DBCC INDEXDEFRAG statements are used, as you are aware defragmentation on table does not yield performance gains in every case. Every scenario is different. Similarly, determining when you...

Filed under: sql server, performance, fillfactor, indexes, database