开发者

SQL 2005 tempdb growth and DTA syntax errors

开发者 https://www.devze.com 2023-01-23 18:10 出处:网络
I arrived at work to today to discover one of our SQL 2005 servers had run out of disk space. On examination the database causing the problem was tempdb. It seems to have grown from around 8mb to 16g

I arrived at work to today to discover one of our SQL 2005 servers had run out of disk space. On examination the database causing the problem was tempdb. It seems to have grown from around 8mb to 16gb, causing me some concern. After kicking everyone out of the server and restarting the problem the tempdb is now back to its original size, not a problem.

So I now decided to try and trace the query(s) causing the tempdb to grow. Th开发者_高级运维ere are only two active databases on the server so I launched the SQL server profiler. I ran it using the "blank" template with the following events selected:

  • All of Errors / Warnings
  • T-SQL
  • Stored Procedures

I then threw this into the database tuning advisor which is now reporting that "67% of the consumed workload has syntax errors".

Question1) should I be worried about such a high level of syntax errors? The errors are coming from a very well known supplier of project management software, should I be contacting them regarding these errors?

Question2) Are the events I selected likely to discover the root cause of my tempdb growth?

Apologies for the long questions, trying to include as much details as I can.

Thanks in advance for any advice I receive.


I have used this one Properly Sizing the SQL Server TempDB Database to monitor the growth. Hope this helps.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号