SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Misbehaving application
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

robnielsen
Starting Member

2 Posts

Posted - 05/31/2006 :  11:43:30  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Sri Lanka
1378 Posts

Posted - 05/31/2006 :  15:05:38  Show Profile  Reply with Quote
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 - 05/31/2006 :  15:13:49  Show Profile  Reply with Quote
No I don't have the source code.
Go to Top of Page

Srinika
Flowing Fount of Yak Knowledge

Sri Lanka
1378 Posts

Posted - 05/31/2006 :  15:32:21  Show Profile  Reply with Quote
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 - 05/31/2006 :  20:31:28  Show Profile  Visit cmdr_skywalker's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 05/31/2006 :  21:00:03  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000