Sounds as this is something on SQL side and some SQL debugging will be required to see where does the whole thing get stuck. All my SQL clusters have only 1 virtual node (but up to 8 instances and then up to 20 databases per instance) and I have never seen any behaviour as yours.
I suspect as much myself. I have logged a call with EMC Support as well just genereally trying to find out if there is anything in NetWorker that could cause this issue. Not being a DBA myself makes it a little more tricky to troubleshoot as I have to rely on what the DBA's are telling me.
That said my colleagues and I all think this is something specifically to do with that instance and possibly some setting somewhere.
Will be doing more troubleshooting today and over the next few days so will provide an update if we find the answer.
ble1
4 Operator
•
14.4K Posts
0
May 7th, 2011 13:00
Sounds as this is something on SQL side and some SQL debugging will be required to see where does the whole thing get stuck. All my SQL clusters have only 1 virtual node (but up to 8 instances and then up to 20 databases per instance) and I have never seen any behaviour as yours.
MarkL2
3 Posts
0
May 9th, 2011 01:00
I suspect as much myself. I have logged a call with EMC Support as well just genereally trying to find out if there is anything in NetWorker that could cause this issue. Not being a DBA myself makes it a little more tricky to troubleshoot as I have to rely on what the DBA's are telling me.
That said my colleagues and I all think this is something specifically to do with that instance and possibly some setting somewhere.
Will be doing more troubleshooting today and over the next few days so will provide an update if we find the answer.