HPE Community
Server Management - Systems Insight Manager
1754420 Members
2780 Online
108813 Solutions
New Discussion

tempdb issues

 
Simon Davis
New Member

‎12-19-2007 09:23 PM

‎12-19-2007 09:23 PM

tempdb issues

On the sql server 2000 where the Insight db's are located, the log file for tempdb is growing at over 60GB/month. In trying to ascertain what is causing the growth I have found that there is a transaction blocking me from doing so. The transaction is being run by user SIMAdmin from the application jTDS on the database vmm_db_v2. I have also noticed that the transaction has been running for a month since the last time the server was restarted.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.