Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerCentral Runs sp_Blitz - Performance Part 2 Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 12:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item SQLServerCentral Runs sp_Blitz - Performance Part 2






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1433597
Posted Thursday, March 21, 2013 9:00 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:45 PM
Points: 4,128, Visits: 5,837
Steve, I wonder if you don't have too many tempdb files. I have lost track of the number of clients I have come across that cause IO performance problems by having too many files (of any SQL Server type) on too few spindles. Causes head thrashing and you get killed by the disk access/seek times. Unless you have demonstrated tempdb object allocation issues or have a boatload of spindles (or SSDs) you may get better IO with fewer files.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1433843
Posted Thursday, March 21, 2013 9:04 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
Good point. Our IT staff used the best advice at the time, which was 1 per core. It's possible that we should reduce down to 4 files.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1433846
Posted Thursday, March 21, 2013 11:55 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:08 AM
Points: 331, Visits: 1,356
Nice article and some good links to useful videos
http://technet.microsoft.com/en-us/sqlserver/ff977043
Post #1433946
Posted Monday, April 22, 2013 9:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 1,833, Visits: 731
Once again great article and great tool.

I am still trying to work out how to get Blitz to count the number of instances on one server.

Cheers

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1445031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse