Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Misbehaving application

Author  Topic 

robnielsen
Starting Member

2 Posts

Posted - 2006-05-31 : 11:43:30
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?

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-05-31 : 15:05:38
Is it in T-SQL or some other language ?
U have the source code of the program?


Srinika
Go to Top of Page

robnielsen
Starting Member

2 Posts

Posted - 2006-05-31 : 15:13:49
No I don't have the source code.
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-05-31 : 15:32:21
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 ?

Srinika
Go to Top of Page

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 2006-05-31 : 20:31:28
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?

May the Almighty God bless us all!
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-31 : 21:00:03
uninstall the apps? you can't control the size coz my guess they're dsql...

you can however increase the size of the tempdb or allocated more drive space to it

quote:

Is there any way to limit the size of the statements that are stored, or disable completely?



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -