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)
 tempdb expands to full harddisk size suddenly
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

anniech2000
Starting Member

12 Posts

Posted - 05/27/2007 :  21:51:20  Show Profile  Reply with Quote
Yes Kristen & DMcCallie, my tempDB problem occurs in production server not only once. So I must find out the actual reason rather than shrinking it only.

My query is a simple select statement which return data of one row and 2 columns, no cursor and no large data. And it finish within 1s when i run it in Query Analyzer directly using exactly the same parameter. However, when i try to run this query in the web site, it runs for a long time. So that's why i think it is the problem of the "remote procedure call" rather than "running of the query". I need to further investiage into the problem.
Go to Top of Page

anniech2000
Starting Member

12 Posts

Posted - 05/30/2007 :  21:38:07  Show Profile  Reply with Quote
Finally, I found that the SQL query runs well directly in SQL analyzer, but runs a long time through JDBC in my program and causes the tempDB expansion. It contains some sub-queries. I re-write it and now the problem is solved. Thank you for all of your help!
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 05/31/2007 :  05:06:13  Show Profile  Reply with Quote
The setting in JDBC (and/or the ADO/OLEDB/ODBC drivers) for the type of "cursor" that the Client uses to process the records in the resultset may be set wrongly.

Kristen
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 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.09 seconds. Powered By: Snitz Forums 2000