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

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 (https://blog.sqlauthority.com)

SQL Scripts
Previous Post
SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name
Next Post
SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2

Related Posts

1 Comment. Leave new

  • hi pinal, thaks for sharing your blog post over here, I have read the first blog post of yours on sql mag and also the current one, both give good info to start of with, can you also share any of your saved scripts for debugging and resolving issues quickly in your articles?



Leave a Reply