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: June 2012

How Local Variable or Optimize for Unknown Resolve Parameter Sniffing


In my last post , we have gone through the parameter sniffing  and possible solutions for parameter sniffing. In the possible solutions except the local variable and Optimize For Unknown are very straight forward solution and we know how they helps us to resolve the issue.In this post we will…

Read more

0 comments, 1,508 reads

Posted in PracticalSQLDba on 27 June 2012

SQL Server : Parameter Sniffing


Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure. Her complaint was one stored procedure is taking long time from the application but completing in two seconds in SSMS.I told her it might be due to parameter sniffing but…

Read more

9 comments, 4,900 reads

Posted in PracticalSQLDba on 25 June 2012

Connection Pooling :At a Glance


What is a Connection Pool?

A connection pool is a group of database connections (with same connection properties) maintained in the application server so that these connections can be reused when future requests to the database are required.Creating a connection to the database servers is a  time consuming process.To establish…

Read more

3 comments, 3,444 reads

Posted in PracticalSQLDba on 15 June 2012

SQL Server : Moving System, resource and User Databases to New SAN disk


In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive to the new SAN. In this post let us go through the steps that we have followed to move the System,Resource and User databases to the new SAN.The environment that…

Read more

6 comments, 2,702 reads

Posted in PracticalSQLDba on 12 June 2012