tempdb.mdf file way bigger than veeam.db

Availability for the Always-On Enterprise

tempdb.mdf file way bigger than veeam.db

Veeam Logoby futureweb » Sun Aug 07, 2016 10:42 pm

Hi,

not sure, it might be normal, but our tempdb.mdf is 20 GB of size, while veeambackup ist 7,6 and logs are 5 GB.

Is this normal?

Thanks
Patrick
futureweb
Enthusiast
 
Posts: 55
Liked: 5 times
Joined: Thu Sep 03, 2015 12:15 am
Full Name: Patrick

Re: tempdb.mdf file way bigger than veeam.db

Veeam Logoby Gostev » Sun Aug 07, 2016 10:57 pm

Hi Patrick, yes this is not uncommon. Because we operate with the database in SQL 2005 compatible mode, many basic SQL operations leverage tempdb heavily. This should largely go away with 9.5, for which the minimal supported SQL Server version will be 2008. Thanks!
Gostev
Veeam Software
 
Posts: 21441
Liked: 2361 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: tempdb.mdf file way bigger than veeam.db

Veeam Logoby futureweb » Thu Feb 02, 2017 10:51 pm

Hi,

is there anything specific we have to do in 9.5 with SQL 2014, to get the tempdb.mdf smaller again?
Running 9.5 now, with U1, tempdb.mdf is still 26.2 GB big.

Thanks
Patrick
futureweb
Enthusiast
 
Posts: 55
Liked: 5 times
Joined: Thu Sep 03, 2015 12:15 am
Full Name: Patrick

Re: tempdb.mdf file way bigger than veeam.db

Veeam Logoby Gostev » Sat Feb 04, 2017 1:48 am

I don't have much experience in SQL Server, but from what I remember there was a compact/shrink operation you could perform on any database... have you tried that?
Gostev
Veeam Software
 
Posts: 21441
Liked: 2361 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: tempdb.mdf file way bigger than veeam.db

Veeam Logoby futureweb » Sat Feb 04, 2017 2:40 am 1 person likes this post

Oh ok, I thought it's something with Veeam 9.5, not doing it at the db itself.
Normal shrink didn't work, but shrinking the file by explicitly telling it the new filesize worked. (as it was 26 GB big, but 99 % free).

Thanks
Patrick
futureweb
Enthusiast
 
Posts: 55
Liked: 5 times
Joined: Thu Sep 03, 2015 12:15 am
Full Name: Patrick

[MERGED] tempdb keeps growing

Veeam Logoby marieelieg » Thu Jul 27, 2017 12:09 pm

Hello everyone,

I have Veeam v8 installed. The Veeam Backup DB is installed locally on the Veeam server on sql server 2012. No other instance or database is installed on this sql.

The tempdb (system db that sql creates during installation) is still growing and now is around 70 GB. I have read that this tempdb is used for temporary transactions and should return to normal size when those transactions are done. I also read that some applications fail to "tell" this tempdb that the transactions are done and that's why it keeps on growing, and upon restart of the server, tempdb should return to normal size.

I did restart the server, however, tempdb is still 70GB.

I need to know how to fix this.
Is this an issue related to Veeam 8.0?
If I upgrade Veeam to 9.5, will this issue be solved?

Any help is much appreciated!
marieelieg
Enthusiast
 
Posts: 66
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: tempdb keeps growing

Veeam Logoby PTide » Fri Jul 28, 2017 12:10 pm

Hi,

Update to 9.5 should help (see the posts above). Anyway, I'd recommend to contact our support team first. Once you do please post your case ID.

Thanks
PTide
Veeam Software
 
Posts: 3078
Liked: 251 times
Joined: Tue May 19, 2015 1:46 pm

Re: tempdb.mdf file way bigger than veeam.db

Veeam Logoby marieelieg » Fri Jul 28, 2017 12:15 pm

Hello PTide,

No I haven't yet. On Monday I will be upgrading to Veeam 9.5. If the problem still persists then, I will open a case with Veeam.

Thanks!
marieelieg
Enthusiast
 
Posts: 66
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 39 guests