SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Fri, 14 Jan 2011 01:30:55 +0000 Indexed on 2011/01/14 1:56 UTC
Read the original article Hit count: 626

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

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about PostADay