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

SQL Server ETL Performance during Data Load Optimization

Published 20 December 7 8:40 AM | SSQA.net

Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL...

Filed under: sql server, performance, indexes, backup, etl, disable, bulk insert, slow query, alter index, load

FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005

Published 2 August 7 9:17 AM | SSQA.net

There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may...

Filed under: performance, backup, optimization, disk space, full-text

Get backup and restore performance stats with a DMV

Published 12 June 7 8:25 AM | SSQA.net

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included...

Filed under: sql server, stats, performance, restore, backup, dmv, read

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