Can anyone recommend a good performance tuning series?

Question

Post reply

Can anyone recommend a good performance tuning series?

derek.colley

SSCrazy Eights

Points: 8040
More actions
May 18, 2012 at 7:25 am

#258409

Hi
Just wondering if anyone has stumbled across any SQL Server performance tuning video runs or stairway-type article series that are worth a look?
I've got a couple of books about it including SQL Server 2008 Internals & Troubleshooting (really good) but I wondered if you guys have anything you refer to regularly that you think is worth viewing?
I'm fairly familiar with the perfmon SQL counters and what to watch out for, and with a number of DMVs, so I'm looking for intermediate/advanced material rather than beginner stuff.
Thanks!
---
Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:
Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 1

brent ozar does some excellent video podcasts - http://www.brentozar.com (i think)

MVDBA

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 2

http://www.brentozar.com/sql-server-training-videos/

MVDBA

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 3

Thanks Mike, just what I was looking for. If anyone else has suggestions too they would be greatly appreciated.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.