SqlServer-QA.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 within SQL Server 2005 version that was lacking in previous versions. The following blog ...

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 role, on the execution of queries ensure that columns that are included in the WHERE ...

It is evident that well-designed indexes will help a lot in attaining performance for a poorly performing queries, this can also reduce disk I/O operations by consuming lesser resources on the server. Maily indexes are helpful during SELECT queries and must be carefully adopt when there are much UPDATE or DELETE statements are involved within your ...

Yet another help from DMV I would like to share here, say on a SQL Instance you are getting low-level I/O and blocking intermittently. For the I/O issues using SYSMON (PERFMON) is ideal to get more information during the busy times and low-usage times (for memory too WhatUNeed2Check post). For the blocking in SQL 2000 & 70 version you can ...