SQL Server Performance Forum – Threads Archive

threshold exceeded

hi I have got an error stating that the "Transactions Per Second exceeds a certain threshold in tempdb" can anyone tell me how to solve this problem?
vky

Trasaction per second threshold is depends on your database/server activity…
You guys might be creating lot of temp tables or optimizer migt be creating temp tables when executing the queries….. Why you are worried about it and is there any peformance issue? You can optimize your queries/procedures…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>