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.
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.
Head over to original article over here: Quick Look at SQL Server Configuration for Performance Indications.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Filed under: Pinal Dave, PostADay, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology