Tempdb has autogrown, for better performance expand tempdb files

[Former Member]

Hi,

I have this warning in SAP Management Console:

Tempdb has autogrown, for better performance expand tempdb files

This is SQL server 2005 with ECC 6.0

How can i solve this problem?

Kind regards,

Nuno Silva

[Former Member · Accepted solution]

Hi

What you need to do (or Basis team) is through the SQL or enterprise manager (or studio) whichever applies to your case. Open it and then navigate on the left menu to the tempdb and right click->properties. Then in properties goto the tab for where is shows you the files and simply change the value from 337 to whatever you feel adequate and ok it.

The other option is to do it with a sql cmd in query analyser, but more complicated if you're unsure.

In both cases seek help from a more experienced basis person if you're unsure of what you're doing.

Hope this helps you.

Pedro

[Former Member]

Hi Nuno,

The way it looks to me (correct me if my assumptions are incorrect), you must have had initially the tempdb size at 250 or 300MB and set to autogrow. It is now 337 which means it had to autogrow at some point. Auto growth causes performance decrease and that's what your message is indicating.

To resolve this set your tempdb size to 350 for example to see if that stops it having to extend.

Hope it helps

Pedro

[Former Member]

Hi Pedro,

How can i do the your recomendation?

Kind redards,

Nuno

[Former Member]

What is your current size of Tempdb ?

Regards,

Nikunj Thaker.

[Former Member]

Hi,

tempdb - 337.920 KB

templog - 51.200 KB

Kind regards,

Nuno

[Former Member]

I agree with Pedro Freitas.

Regards,

Nikunj Thaker