The dashboard might be good, but I doubt I am able to have it installed. I'll see.

Since the link to the dashboard says it uses the dynamic mgt views,...

If anyone knows a command from sql server that provides cpu utilization %, please post it.

I need to save this in a table on an hourly basis, in order to...

yes, you're both right.

I am of the old school, including work with Sybase, and have not used maintenance plans too often.

I am familiar with coding scripts to do this tye...

I see your point.

I would like point in time recovery. As it is now, they only do a full backup daily. Then loads run and if we have...

My thought is to run the daily full backup and at the end, do a backup log with init.

Then the rest of the day is with noinit.

This is a DW...

Gail,

If I backup log with init once a day, then with noinit the rest of the time, then it's one backup log I have. So there is only one...

Yes, it truncates the unused part of the log prior to the oldest active transaction.

There were no open tran at the time. That's why I found it odd that...

I understand 5 GB is not big.

I just took responsibility for the SQL Server from another group and there is a script that monitors database size to protect from runaway...

I also did dbcc shrinkdatabase(tempdb)

and dbcc shrinkfile (tempdb, 2000, notruncate)

then did a truncateonly

Why I need to know? I have a db in simple recovery mode and there's alot of loading running overnight.

It causes the logs to expand large enough that I...