Browse by Tags

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

Published 14 May 8 3:23 AM | SSQA.net

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework

SQL Server 2008 Resource Governor FAQ

Published 25 February 8 1:36 AM | SSQA.net

Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...

Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Published 21 February 8 6:22 AM | SSQA.net

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...

Filed under: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow

SQL Server 2005 DMV - how it can help to consider whether index is useful or not?

Published 4 February 8 8:6 AM | SSQA.net

When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views...

Filed under: sql server, performance, indexes, dmv, dba, performance monitoring, index plan

SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV

Published 14 January 8 2:22 AM | SSQA.net

It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA...

Filed under: sql server, performance, indexes, maintenance plan, dmv, dba, best practice, performance monitoring, sys.dm_db_index_physical_stats, measures

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

Disk Space Requirements for Index DDL Operations

Published 28 September 7 8:38 AM | SSQA.net

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...

Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing

Dedicated Administrator Console (DAC) - saved an important day for a DBA

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

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...

Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation

SQL Server 2005 Performance Dashboard Reports - making most out of it!

Published 26 June 7 4:19 AM | SSQA.net

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow...

Filed under: dashboard, sql server, performance, databases, dba, reporting

How to find list of DMVs & DMFs?

Published 31 May 7 9:22 AM | SSQA.net

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism...

Filed under: sql server, performance, management, microsoft, dmv, dba, dmf

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