F5 LTM 10.2 and MSSQL 08R2

Question

We have a mirrored SQL server setup with a pair of LTM's holding the mirror VIP. We're trying to setup a health monitor that runs a query against both servers in the mirror and directs traffic to the principal. Right now we have a query running that should only be possible on the active side of the mirror, but it's showing that both nodes are green. Any ideas?

Any updates? Im looking to do the same thing. Im thinking it would need a query of a specific DB. Im thinking along this line - exec sp_dbmmonitorresults [DB Name] If the Role returns a 2 its passive. If 1 its active. Make sense? — , Jan 17 '12 at 16:31

score 0 · Answer 1 · edited Nov 07 '12 at 16:25

0

SELECT mirroring_role_desc FROM sys.database_mirroring WHERE database_id=(Your database number) --expected response = 'MIRROR' or 'PRINCIPAL'

edited Nov 07 '12 at 16:25

Scott Pack

14,907
10
53
83

answered Feb 22 '12 at 20:15

W2R

1

score 0 · Answer 2 · answered Mar 01 '15 at 16:57

0

F5 can't natively support queries directly against a database. As such, this may be why you are having an issue. You may want to look into external health monitors

answered Mar 01 '15 at 16:57

James Shewey

182
14

F5 LTM 10.2 and MSSQL 08R2

2 Answers2