Yeah as mentioned in the OP I have a listener for the group, although I can use that in a connection string, how do you query the database thats part...

Have figured it out by using this query:

SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan, plan_handle

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

CROSS APPLY sys.dm_exec_query_plan(plan_handle)

WHERE TEXT like '%%'

Hi all thanks for the replies I will be testing and posting results back as soon as I can. Its our last day at work here and I have...

Hi there - I have attached the files for the definitions and also the execution plan

Thanks

Indeed - I am currently pulling out queries that are using parallelism and looking to tune them as a start. Then hopefully I will get a good idea of...

Hi there - wow that query is excellent, thanks.

Ok I think we have go to the bottom of it.

When he was expanding the Views section it was saying something like "Please view Object Explorer Details" in a blue...

He is looking in SSMS, I ran the code and can see a list of views, I also got him to run it and he gets a list back.

Running sp_helptext...

OK the GUI for the Mirroring Monitor is reporting correctly now, I removed and re-created the mirror.

Another point if I run

select * from sys.dm_db_mirroring_connections

I see 4 connections even though I have 5 databases mirrored, although perhaps one DB just isn't being accessed.

If I run:

select * from...

The only testing I did was to monitor the network interfaces for a week or so to see how much they were being utilised, and found that they were ok....

They are all at 10sec, I guess I could increase it, but was really wondering why it happened in this manner in the first place.

OK thanks

Hi Perry

I am thinking now that we perform SAN backups around that time and perhaps the network was flooded.

What kind of details would you like?

Thanks

OK in case anyone was interested I have found more out.

These errors were occurring for me when I had configured SCOM to monitor by using a WMI alert. The...