My 2 cents..

Dont run the profiler on the server... run a server side profiler(script) through a job..that should have very less over head..also select only those events that you need..

Please find the activity monitor screen shot attached

I have very few databases that I am planning on HA...but the transaction rate is very high..almost 10 million inserts to one table a day

Thank You...I have scheduled to go on installing the updates on staging env. tonight. I will plan on monitoring for 1 week before I update the prod server.

The last time the updates were run on this production DB server was in July,2011.

I meant anything other than using FailoverPartner in High performance mirroring.

Thanks for the info...so what are the best high availability options that we have where we need not worry about changing connection strings irrspective of automatic or manual failover?

Hi everyone,

Quick thing...Do we need to make changes to the connection strings of a web/app server config file if we implement DB mirroing in high performance automatic failover mode? I...

I increased the size of the log for index rebuild and now want to release the unused space in the log. I did a transaction log backup with Truncate the...

ok..thank you

Also I forgot to mention that the DETA recommended to create a lot of statistics along with the indexes. Right now I am about to rebuild the indexes. Is it...

80

Sure. I just verified again if any of our databases are shrinking through any maintenance plans or jobs and I don't see it happening.

Wondering why it happens so quickly.

The other thing I noticed is the indexes are fragmented heavily back within less than a week. I understand there are lots of inserts and updates happening. But is that...

Gail,

I dont see anything in the stored procedures folder and in the trace file I see sp_executesql followed by the queries and the trace was filtered with only a specific...