Post reply

some random questions for monitoring

  • April 21, 2009 at 8:09 am

    #130200

    Hi all,

    I'm making myself a little gui frontend to display some information about my sql servers.. not so much because I need it, I know there are plenty of commercial and some free tools which will do it for me, but because I tend to learn better by doing, so I'm using it as a learning opportunity for myself.. the more i know etc etc..

    So, on to my questions..

    Is there somewhere in SQL server which lists number of failed logins per username? I know I can set it to insert into the event viewer on the server, but was wondering if there was a table I could query. I was hoping to be able to pull total number of failed login's per user for a set timeframe.

    Is there some way to know when a task like an index rebuild is occurring without looking at the sql agent job list? So for example, if someone was to manually run an index rebuild.. is there something somewhere which tells me this is happening right now? Something I could possibly pull from sysprocesses? Same sort of question for backups etc. Once I know where to start I think i can work through it

    How can I tell how many active transactions I have on the go at any one time? I was thinking of using

    select COUNT(*) from sys.dm_tran_active_transactions

    Would that be valid?

    Finally (for now at least) -- Does someone have a link for a good description of what each System View in master actually shows and what its good for?

    Thanks

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • April 21, 2009 at 9:41 am

    #981558

    I don't think you can get a count of the failed logins per user. They're logged, but you'd need to load that into a table and query it. There might be a system view, but there are so many now.

    For active trans, I think that query might work, but it would be instantaneous. You'd need to store this value avg to get an idea of load, peaks.

    System views:http://msdn.microsoft.com/en-us/library/ms177862.aspx

  • April 21, 2009 at 9:45 am

    #981563

    Thanks Steve,

    I didn't know if the logins would store that.. though it'd be handy.. ah well.

    Thanks for the link, i'll check that out shortly. I'm sure I'll have more questions 😀

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply