locked
sp_dbmmonitorresults related question RRS feed

  • Question

  • hello everybody, i'm lookign to get the unsent log queue , i know i can get using the sp_dbmmonitorresults, but i need just the unsent log colum, is there any table i can make a query, so i just get the value that is in this table ?? without having to resort to temp tables ?? 

     

    thank you in advance 

    Thursday, March 17, 2011 1:37 PM

Answers

  • Did you look at msdb.dbo.dbm_monitor_data?

    Check code of sp_dbmmonitorresults in msdb.

     -- Here's what we do 
     -- 1. create a cursor to loop over the rows in the data table 
     -- 2. get one row of data 
     -- 3. while (we should loop is true) 
     -- 4. get the next row of data might break out of the loop here. 
     -- 5. calculate differences between rates 
     -- 6. calculate the difference in "time" between the failover LSN (what the mirror has) and the end of log LSN (the latest value on the principal) 
     -- 7.   insert the data into the table 
     -- 8. copy older values of data into newer values (basically we are doing step 2 here.  or putting step 4's data into the original 
     --   variables since we are done with that information anyway. 
     -- 9. loop to 3. 
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Thursday, March 17, 2011 3:05 PM