December 11, 2015 at 1:11 am
Hi,
The log of my tempdb is growing:
This is the result of DBCC SQLPERF(LOGSPACE);
tempdb7700.49261.158730
Its normal ?
thank you
December 11, 2015 at 1:51 am
Log growth is normal.
Is the growth rate your seeing normal, who knows.
You will need to monitor whats using TempDB to see whats causing the log growth, maybe you had a run away process, or maybe a new process has started, data changed etc.
December 11, 2015 at 2:04 am
It goes to almost 100 and then starts again from 0
December 11, 2015 at 2:17 am
Then monitor what is using TempDB and define if this is normal or not.
If not go speak to the person who is causing the issue and work with them to alleviate the growth on TempDB where at all possible.
December 11, 2015 at 9:15 am
Is the log size growing, or just the % used? You don't want the log size to grow dynamically, as that will slow down the database. But tempdb log space % used fluctuating up and down is quite normal.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 11, 2015 at 12:13 pm
That's what I wanted to know. Thanks for clarify
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply