Yes, under the Events tab in Profiler, select the Objects event class and add all or the appropriate ones for your monitoring.

Have you looked at the activity on this database to determine what minimally logged operations are being run and expanding the logs through either a trace or looking at the...

Far shot here but is it possible that this database still sees itself as a publisher and has trasactions waiting to be replicated to the distributor? Have you disabled publishing...

With distance comes increased latency so, depending on the amount of transactions you are replicating, and the amount of distance you are travelling, will determine how much latency you are...

I remember years ago MS had some recommendations but even that there was nothing concrete that I had found. Still haven't seen any yet. If you find them please post...

When you say you solved the problem, did you kill some really offensive query? 😉 Being that CPU wasn't pegged and Disk IO wasn't the issue, there isn't much else...

Are you using native SQL backups? If so, compression will definitely help. There are some nice 3rd party tools out there that can bring the time and the size of...

More information "Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator...

"Setup is aborting as the current user is not in the administrator group." shows up not to long before the failure. Are you an admin on this box / instance?

Thanks Gail. I was just about to start testing this too because I believe I have seen it pick up missing indexes without having anything in the where clause as...

There far too many variables to consider when looking at defining a good disk configuration to recommend but we use information based on read / write activity and stall information...

I am not to familiar with Express so, there are probably others that can help more in this area. Have you had any other disk related errors or any IO...

This is by design so that data consistency can be maintained. There are some things you can probably to do alleviate some of that but not without certain risks being...

The first two you can run anywhere but they are just information for the instance level security. The second two need to be run in the individual databases.

You would want to look at some of the system stored procedures to get this information including sp_helpsrvrolemember, sp_helplogins at the server level and sp_helpuser, sp_helprolemember at the database level....