November 2, 2017 at 1:36 am
Dear all,
we have a complaint about an application that is very slow. Its database has 1GB in size but the tempDB on the server has 200GB.
If possible, I would like your advices on how should I start this investigation.
Probably, there is something filling the TempDB with lots of infromation.
Thank you,
Pedro
November 2, 2017 at 1:52 am
river1 - Thursday, November 2, 2017 1:36 AMDear all,we have a complaint about an application that is very slow. Its database has 1GB in size but the tempDB on the server has 200GB.
If possible, I would like your advices on how should I start this investigation.
Probably, there is something filling the TempDB with lots of infromation.
Thank you,
Pedro
Check the queries running on the server, check the CPU and memory utilization. You sure the TempDB grew gradually? TempDB filling up is mostly caused by poor performing queries.
November 2, 2017 at 8:09 am
river1 - Thursday, November 2, 2017 1:36 AMDear all,we have a complaint about an application that is very slow. Its database has 1GB in size but the tempDB on the server has 200GB.
If possible, I would like your advices on how should I start this investigation.
Probably, there is something filling the TempDB with lots of infromation.
Thank you,
Pedro
Try using the scripts in the following blog - it walks through tacking down some tempdb usage:
Script to Find and Monitoring TempDB Space Usage
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply