Tempdb is filling due to background process.
-
I have it narrowed down to which session id is causing the issue, but that session is a background session with a command of "DB Startup"... I just cycled the instance less than a week ago due to the same issue, and I don't want to do it again without understanding why.
DB is part of a availability group and does have Query Store enabled.
What else do I need to be looking at?
-
<deleted>
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Log backups are hourly. There doesn't appear to be any significant lag within the availability group as far as I can tell.
-
Are your applications using Snapshot Isolation level ? ( also have a look at "tempdb tutorial"
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
<deleted>
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
The OP said "but that session is a background session with a command of "DB Startup" and that he has the logfile being backed up an truncating every hour but the real problem is the growth it's causing in TempDB. They also said "DB is part of a availability group and does have Query Store enabled."
I don't know the fix for the issue but I'm thinking that logfile backups are not the problem here.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
OMG. I'm so sorry. Deleting my responses. Reading is fundamental and I have failed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply