Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here.
Read second part over here: Quick Look at SQL Server Configuration for Performance Indications.[Articles are relocated so links are disabled]
In this second part I talk about two types of my clients.
1) Those who want instant results
2) Those who want the right results
It is really fun to work with both the clients. I talk about various configuration options which I look at when I try to give very early opinion about SQL Server Performance.
There are various eight configurations, I give quick look and start talking about performance.
Reference : Pinal Dave (http://blog.SQLAuthority.com)