Home Forums SQL Server 2005 Administering Transaction/Sec on tempdb RE: Transaction/Sec on tempdb
NicHopper
SSCrazy Eights
Points: 9090
More actions
February 3, 2009 at 7:45 am
#937136
Hi,
Yes, original I just looked at the total, then to try and find the cause I added the user db's and the temp db.
As mentioned the tempdb accounts for approximately 95% of the total transaction/sec.
Thanks.
Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/