We have an application that is generating thousands of unique select statements. This is causing the tempdb to continue to grow because the statements are getting stored in the tempdb. Is there any way to limit the size of the statements that are stored, or disable completely?
Very hard to tell much, without u providing with more info as, what kind of a program is it ? Language it is written ? How it is connecting to the DB ? Whether the whole program is of no use etc.
Do u want the selection to be stopped in SQL server's end ? All Selections or some selections ?
what do you mean by "generating thousands of unique select statements"? Does this mean generates numerous select statements with distinct (i.e. SELECT DISTINCT, SELECT DISTINCT, SELECT DISTINCT..) OR a SELECT DISTINCT statement returning thousands of records?
Misbehaving application
Posted - 05/31/2006 : 11:43:30
