SQL 2005 tempdb 增长和 DTA 语法错误
今天我上班时发现我们的一台 SQL 2005 服务器磁盘空间不足。 经检查，导致问题的数据库是 tempdb。它似乎从 8mb 左右增长到了 16gb，这引起了我的一些担忧。将所有人踢出服务器并重新启动问题后，tempdb 现在已恢复到其原始大小，不再是问题。
所以我现在决定尝试跟踪导致 tempdb 增长的查询。服务器上只有两个活动数据库，因此我启动了 SQL Server Profiler。我使用“空白”模板运行它，并选择了以下事件：
- 所有错误/警告
- T-SQL
- 存储过程
然后我将其放入数据库调优顾问中，该顾问现在报告“所消耗的工作负载的 67% 存在语法错误” 。
问题1）我应该担心如此高水平的语法错误吗？这些错误来自一家非常知名的项目管理软件供应商，我应该就这些错误联系他们吗？
Question2) 我选择的事件是否可能发现我的 tempdb 增长的根本原因？
对于这么长的问题，我深表歉意，我试图包含尽可能多的细节。
预先感谢我收到的任何建议。
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. There 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我使用了这个正确调整 SQL Server TempDB 数据库大小来监控增长。希望这有帮助。
I have used this one Properly Sizing the SQL Server TempDB Database to monitor the growth. Hope this helps.