Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

PracticalSQLDba

I have total of 11 years of IT experience with Application development, Database Development and Database Administration. I have worked with different version of SQL server from 7.0 to 2008.Started my carrier as VB ,VC++ and database developer in a banking sector for implementing their core banking solution. Currently working as Database Administrator with wide knowledge in performance tuning, high availability solution, troubleshooting and server monitoring. This blog is my humble attempt to share my knowledge and what I learned from my day to day work.

Archives: April 2012

Windows 2008 Server : Moving Cluster Quorum Disk to New SAN


In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we will go through the procedure to move the quorum drive to the new SAN. Follow the steps mentioned in the earlier post to add the new disk to the…

Read more

1 comments, 3,024 reads

Posted in PracticalSQLDba on 23 April 2012

SQL Server: Measuring The Index Fragmentation


In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance. In this post we will discuss about measuring the index fragmentation.

Measuring Internal Fragmentation 

Internal fragmentation  is all about the fullness of the page and it is measured using…

Read more

15 comments, 6,430 reads

Posted in PracticalSQLDba on 20 April 2012

SQL server: Deciphering Wait resource


When I was working with couple of frequent blocking issue in our live server, I have noticed different types of wait resources which are not meaningful unless they mapped to a table or an index. In this post I will explain how to map the wait resources to table/index.


Key…

Read more

4 comments, 4,392 reads

Posted in PracticalSQLDba on 12 April 2012

SQL Server - Index Fragmentation - Understanding Fragmentation


When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding about index fragmentation. In this post I will try my level best to explain different types of fragmentation.Understanding the concept of index fragmentation is important  for detecting and removing fragmentation efficiently.

Read more

20 comments, 14,062 reads

Posted in PracticalSQLDba on 5 April 2012