yes, SP3;

sys.database_files still has zero for growth, even though today, also the TempDB grew!

I am hoping to find a way to do this, without restarting the SQLService.

Jeff & Mike

Thanks for your input on the RO DBs. yes, RO has it's downfall, but some of the good features that would work for us are RO featured (Mirror,...

sure. I will add it.

before that what perfmon counters can i run to see before and after permformance metrics.

thanks.

If I have permission to access restorehistory table, I would have thought I would have had permission for the other system tables there, too.

What is the permission that is required...

Jeff

Just thought about it.. we may have to throw in or remove some indexes into the reporting DB.. that essentially rules out the DB Snapshot/Mirror and Shared Database, doesn't it?...

Jeff

Thanks for the points. I have never used mirror before. Do I need one extra server to host the mirror?

Would there be benefits to doing DB snapshop instead of hitting...

Yes, I am trying to put the backup on the existing Database2.

Yes I do not have the pagefile.sys set up (there is no pagefile.sys is any of the drives) 'No Paging File' is setup for the drives.

Page Faults/sec is at 799

No, I did not have any insufficient disk space issues.

Did you notice it only with your laptop DB or all Dbs?

GSquared

I got the link http://www.sqlservercentral.com/articles/Auditing/63247. Thanks.

When you say trace, you mean profiler?

Dan

ALZDBA

I using Microsoft SQL Server 2005 - 9.00.4035.00 (SP2).

I do have the '/pae' parameter in the Boot.ini file

George, good point. But there is not in-built log explorer in SQL Server, is there?

AWE is enabled, but no pagefile.sys is setup for any of the drives. Is this an OK combo?

Perfmon says 'pagefile.sys % Usage' counter is 6 for last 24 hours (last...

How do I explore other MSDB tables?

When I see under System tables, I do not see any of the tables, including the restorehistory table.

I see only these tables:

MSreplication_options

spt_fallback_db

spt_fallback_dev

spt_fallback_usg

spt_monitor

spt_values.

And what are...