<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Timothy A Wiseman
»
An Informal Look at Database Performance
13 posts, Page 1 of 2
1
2
»»
An Informal Look at Database Performance
Rate Topic
Display Mode
Topic Options
Author
Message
timothyawiseman
timothyawiseman
Posted Tuesday, September 07, 2010 11:40 PM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:01 PM
Points: 743,
Visits: 900
Comments posted to this topic are about the item
An Informal Look at Database Performance
---
Timothy A Wiseman
SQL Blog:
http://timothyawiseman.wordpress.com/
Post #982050
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, September 08, 2010 12:09 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367,
Visits: 6,465
Great article. It gives me a nice overview and a bunch of very useful links.
Now I just have to find the time to read them all :)
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #982063
mortenmaate
mortenmaate
Posted Wednesday, September 08, 2010 1:23 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, August 05, 2012 10:04 PM
Points: 1,
Visits: 8
Thanks a lot for the great overview !
One thing I would like to mention additionally:
Look a the SQL Server version
. In my experience many companies upgrade their SQL Server too rarely, and especially in the MS family of SQL Servers, great improvements in the product during the last 10 years can be an easy gain (like factor 10 improvements or even more in some scenarios). So get rid of that SQL Server 2000 bastard now! (Believe me: They
are
still out there).
Post #982082
Jeff Moden
Jeff Moden
Posted Wednesday, September 08, 2010 6:32 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:05 AM
Points: 32,894,
Visits: 26,775
mortenmaate (9/8/2010)
Thanks a lot for the great overview !
One thing I would like to mention additionally:
Look a the SQL Server version
. In my experience many companies upgrade their SQL Server too rarely, and especially in the MS family of SQL Servers, great improvements in the product during the last 10 years can be an easy gain (like factor 10 improvements or even more in some scenarios). So get rid of that SQL Server 2000 bastard now! (Believe me: They
are
still out there).
Heh... I love the older versions of SQL. That's were I learned all the tricks I know to make stuff work.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #982238
Jeff Moden
Jeff Moden
Posted Wednesday, September 08, 2010 6:45 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:05 AM
Points: 32,894,
Visits: 26,775
Well done, Timothy. Definitely "brief case" time for this article. Thanks for taking the time to make it so complete.
The idea of having a baseline and the idea that most of the performance problems are in code are two very important subjects that I try to stress where some stress that hardware is the key. If you buy a server that's twice as fast, the best your code will do is run twice as fast. Tweek the code or rewrite it, and it can run literally 100's of times faster. Why is that important? Heh... look around this forum folks! It's filled with cries for help to make code faster or solve time-outs.
The other item that people seem to stress is that the server needs to be tuned. Just like buying the proper hardware, tuning the server properly is certainly important but most of the performance problems folks run across just can't be solved by additional tuning of the server. You have to fix the code and this article stresses that.
The same goes for indexing. Although you can get great gains from proper indexing (even some triangular joins can benefit), you can get even more from your indexes if your code is actually capable of using them.
"Tune the Code... that's where the performance is!"
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #982243
PFlorenzano-641896
PFlorenzano-641896
Posted Wednesday, September 08, 2010 7:52 AM
Valued Member
Group: General Forum Members
Last Login: Today @ 11:17 AM
Points: 56,
Visits: 254
Nice job Timothy! Your article certainly covers all the bases, troubleshooting, monitoring, & performance tuning.
Taking snapshots of a server throughout the day (under normal conditions) is a great idea so that if performance were to degrade, there would be documented evidence to compare the performance degradation snapshot with the normal snapshot.
Post #982307
ianstirk
ianstirk
Posted Wednesday, September 08, 2010 8:03 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 47,
Visits: 762
Hi,
Nice article.
You can discover a lot more about DMVs in this forthcoming book www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:
A simple monitor
Finding your slowest queries
Find your missing indexes
Identifying what SQL is running now
Quickly find a cached plan
Thanks
Ian
Post #982322
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, September 08, 2010 9:31 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 11:02 AM
Points: 31,410,
Visits: 13,725
Great job, and a very nice read.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #982418
timothyawiseman
timothyawiseman
Posted Wednesday, September 08, 2010 9:39 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:01 PM
Points: 743,
Visits: 900
mortenmaate (9/8/2010)
Thanks a lot for the great overview !
One thing I would like to mention additionally:
Look a the SQL Server version
. In my experience many companies upgrade their SQL Server too rarely, and especially in the MS family of SQL Servers, great improvements in the product during the last 10 years can be an easy gain (like factor 10 improvements or even more in some scenarios). So get rid of that SQL Server 2000 bastard now! (Believe me: They
are
still out there).
That is a very good point to add.
I know from direct testing that the optimizer works much better in 2005 then it did in 2000. I have not tested the query performance going from 2005 to 2008 or R2, but I would be shocked if it got worse.
---
Timothy A Wiseman
SQL Blog:
http://timothyawiseman.wordpress.com/
Post #982431
Nadrek
Nadrek
Posted Wednesday, September 08, 2010 12:29 PM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 12:07 PM
Points: 673,
Visits: 2,030
Nice overview; I'd like to encourage the addition of looking at SQL Profiler CPU, Reads, Writes, and Duration columns on SQL:BatchCompleted events.
Not only do these show aggregates, if you do this on a regular basis, you'll get a good, trained idea of when a query is using "too much" of any of them.
Post #982566
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
