Browse by Tags

• alter database
• auto grow
• best practice
• blogs
• configuration
• dashboard
• databases
• disk space
• disks
• dmf
• dmv
• error log
• hardware
• index plan
• indexes
• maintenance plan
• management
• measures
• microsoft
• monitoring
• new feature
• optimization
• perfmon
• performance monitoring
• reindexing
• reporting
• resource governor
• slow query
• sorting
• sql server
• sys.dm_db_index_physical_stats
• sysmon
• technet

SQL Server - PERFMON counters and Resource Governor - what you can do in a performance issue situation?
17 November 08 12:41 AM | SQL Master | 2 Comments   

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility Read More...

Filed under: performance, sql server, dmv, perfmon, dba, sysmon, performance monitoring, new feature, 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.
21 February 08 05:22 AM | SQL Master | 2 Comments   

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 Read More...

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

SQL Server 2005 DMV - how it can help to consider whether index is useful or not?
04 February 08 07:06 AM | SQL Master | 4 Comments   

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 Read More...

Filed under: performance, sql server, dmv, indexes, 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
14 January 08 01:22 AM | SQL Master | 2 Comments   

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 Read More...

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

SQL Server: How do I identify the queries that are worth tuning?
16 November 07 06:02 AM | SQL Master | 2 Comments   

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). Read More...

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

Disk Space Requirements for Index DDL Operations
28 September 07 06:38 AM | SQL Master | 3 Comments   

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 Read More...

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

SQL Server 2005 Performance Dashboard Reports - making most out of it!
26 June 07 02:19 AM | SQL Master | 4 Comments   

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 Read More...

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

How to find list of DMVs & DMFs?
31 May 07 07:22 AM | SQL Master | 1 Comments   

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 Read More...

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