SQLServerCentral.com / Discuss Content Posted by Steve Jones / Article Discussions by Author / Article Discussions / SQLServerCentral Runs sp_Blitz - Performance Part 2 / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 19:04:46 GMT20RE: SQLServerCentral Runs sp_Blitz - Performance Part 2http://www.sqlservercentral.com/Forums/Topic1433597-32-1.aspxOnce 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. :ermm:Cheers[b][i]qh[/i][/b]Mon, 22 Apr 2013 09:06:52 GMTquackhandle1975RE: SQLServerCentral Runs sp_Blitz - Performance Part 2http://www.sqlservercentral.com/Forums/Topic1433597-32-1.aspxNice article and some good links to useful videos[url=http://technet.microsoft.com/en-us/sqlserver/ff977043]http://technet.microsoft.com/en-us/sqlserver/ff977043[/url]Thu, 21 Mar 2013 11:55:46 GMTJonathan AC RobertsRE: SQLServerCentral Runs sp_Blitz - Performance Part 2http://www.sqlservercentral.com/Forums/Topic1433597-32-1.aspxGood 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.Thu, 21 Mar 2013 09:04:17 GMTSteve Jones - SSC EditorRE: SQLServerCentral Runs sp_Blitz - Performance Part 2http://www.sqlservercentral.com/Forums/Topic1433597-32-1.aspxSteve, 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.Thu, 21 Mar 2013 09:00:49 GMTTheSQLGuruSQLServerCentral Runs sp_Blitz - Performance Part 2http://www.sqlservercentral.com/Forums/Topic1433597-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/SQLServerCentral/96158/">SQLServerCentral Runs sp_Blitz - Performance Part 2</A>[/B]Thu, 21 Mar 2013 00:01:48 GMTSteve Jones - SSC Editor