Check http://sqlconjuror.com/sql-server-always-on-monitoring-script/

and

https://solutioncenter.apexsql.com/performance-monitoring-of-alwayson-availability-groups-part-1/

• This reply was modified 3 years, 10 months ago by Johan Bijnens.

have the user reboot his client pc.

Be wary for stored credentials

indeed, Jeff.

Default trace only last so long ...

Check the comments at SQLSkills article  CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete

Check sqlserver errorlogs ! ( of all involved instances ! )

Check the cluster logs !

what is the state of your servers ?

Why did it fail over ?

Is it only the...

SQL2005 doesn't have XE!

Check your default trace file or run a trace to figure it out !

Did you try this ?

Select *
, stuff(
   (
           select rtrim(T2.postcd) + ', ' 
 ...

what is the actual error and error message you are receiving ?

Everything except OS and backup related.

AFAIK you cannot disable an index on SQL2000 !

syntax "alter INDEX myix ON myschema.mytable disable;" only works as of SQL2005  ...

And even if you can, DO NOT disable index id...

What are you trying to do with notification services ?

Chances are you can do it more easy and less intrusive on your server /  instance using Extended Events !

With...

I hope you also realize the downsides of using that isolation level !

Why the Query Hint NOLOCK is a bad idea

I used to use Notification services for this, but recently we had major down time due to an overload of connections and SSB-queues not getting processed on time.

We are now...

• This reply was modified 3 years, 11 months ago by Johan Bijnens.

you need a query.

If you build a view, you have no "control" over how it gets used. I mean maybe it gets joined with in queries, ...

if you build a...

Have you checked to use Extended Events to capture login information without having to bother for file sizes and queue sizes?

Have a job process the captured file(s) every x minutes