Viewing 8 posts - 1 through 8 (of 8 total)
Other things you can do to analyze tempdb hammering:
1) Find out what sp's hit tempdb:
Script (best if run with results to text mode with space as delimiter):
Exec sp_msforeachdb @command1...
January 10, 2008 at 2:59 pm
Trigger by file size? Absolutely.
You could have a job that runs periodically to put the free space in the files into variables, and then when the free...
January 10, 2008 at 2:41 pm
Tempdb issues in SQL 2000 : I do these two things for tempdb:
1) Apply MS KB recommendations for tempdb concurrency.[/url] This is done in 2005 as a...
January 8, 2008 at 11:37 am
Your skill set, expertise, diligence, and social fit to the workplace is the product you offer; the product an employer buys. Like any product, it is subject to the laws of...
July 27, 2005 at 11:17 am
Always good to keep this tip in mind ... I'm a SQL Server DBA, but have had to develop against other data sources using ADO & OLEDB providers, such as...
July 20, 2005 at 11:13 am
/*
Here is a Windows 2000 CDO example that I created/use in a stored procedure ...
In Win 2K, CDO is integrated into the operating system, so you don't need to...
October 23, 2002 at 12:04 pm
Great article - worked "right out of the box"!
May 6, 2002 at 12:53 pm
We were having an issue with orphan SQL sessions caused by a web application running on NT4/IIS 4. Turned out that when the application was moved to NT 2000/IIS...
September 26, 2001 at 11:11 am
Viewing 8 posts - 1 through 8 (of 8 total)