SQL Server Performance Forum – Threads Archive
threshold exceededhi 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?
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…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.