0 Replies Latest reply on Jan 23, 2017 5:08 PM by lazywriter

    Database Performance Analyzer plug

    lazywriter

      1.What industry is your company in?

      Healthcare SSAS

       

      2.How large is your IT shop? (Small (1-250 elements); Medium (251 – 2000 elements); Large (2001 to 10000 elements); Extra-large (greater than 10,000 elements)

      between 25-25 developers

       

      3.Which SolarWinds product are you writing this review for?

      Database Performance Analyzer

       

      4.What problem were you trying to solve when you purchased?

      What stored procedure would give us the biggest band for development's time in tuning it.

       

      5.Did you consider options other than SolarWinds? Who?

      We are also using Idera for other database performance alerting

       

      6.How are you using the product and what benefits have you seen?

      The biggest benefit is watching the performance day to day and having it recognize when plans change.

      It is obvious when plans change as performance suffers but it is good to see which plans are good and which one are not.

      We use it to sent out to all developers the 10 most frequently executing stored procedures as opportunities for performance modifications.

      It is great for finding the  needle in a haystack type questions.

      While not advertised  for auditing, it will tell you what procedures/queries  were running each minute and who was logged in running them.