If you had already 16 TempDB files in SQL Server 2005, could you reduce it to 8, using Alter Database commands?

Also, when you restart the server, do the TempDB files...

Marcin

Is the 2k vs 2005 recommendation for the # of TempDB files from your experience or is it a MS reco?

Thx

Dan

Thanks Grant. I will be installing MOM on the client computer. I prefer not to install any SW on the server as much as possible

Jeff,

I had meant to ask if both the mdf and ndf need the extra space, or is the need just in mdf file. I would think we need the...

ok. Thanks.

How can I check that SQL Server is not paging regularly, and if it is tuned /configured that that paging is not possible. where are these settings.

Marcin

Can you give an example of the 'hand-made tool' - you mean write your own application to process it?

Dan

thanks.

Yes Sir.

Prabhakaran

In case of the data & index separated into 2 filegroups as mdf and ndf files, is the 20-25% free space recommendation apply to both?

Dan

good to know the specifics on the SQL 2000 log backups; we still use them.

Thanks for your input.

BACKUP LOG TO DISK. We keep all the backup of log files in case of need to restore to point in time.

If the data and index files are separated (mdf and ndf), does it matter where the amount of free space is required/needed?

Jeff

Do you always beat the Autogrowth before it kicks in (If you suspect from your monitoring that it is going to happen in the next 2 weeks, do you go...

Jeff

Is the formula [at least 20% and/or 6 months growth] for free file space needed- Is it from your experience, or a formula from MS?

Also if the defrag happens even...

George & BitBucket

Thanks for the 2 points & the reference link. Helpful info on Checkpoint.