December 20, 2017 at 8:23 am
Hello,
I stumbled across this interesting article:
https://www.sqlskills.com/blogs/paul/the-accidental-dba-day-27-of-30-troubleshooting-tempdb-contention/
Would anyone help me find where to setup the transactions/sec in "Perfmon" for the TEMPDB?
There are plenty of SQLServer: counters, but I cannot locate the one that would specifically allow me to pick up the one on TEMPDB.
Thanks,
Richard
December 20, 2017 at 8:38 am
SQL Server: Transactions\Transactions/sec, then select TempDB only.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2017 at 8:38 am
richlion2 - Wednesday, December 20, 2017 8:22 AMHello,
I stumbled across this interesting article:
https://www.sqlskills.com/blogs/paul/the-accidental-dba-day-27-of-30-troubleshooting-tempdb-contention/Would anyone help me find where to setup the transactions/sec in "Perfmon" for the TEMPDB?
There are plenty of SQLServer: counters, but I cannot locate the one that would specifically allow me to pick up the one on TEMPDB.
Thanks,
Richard
For the counters, select the object SQLServer:Databases, for the counter select Transaction/sec and then for the instance select tempdb
Sue
December 21, 2017 at 2:16 am
Ah, found it, THANK YOU 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply