Most company have limited enterprise IT development resources and frequently fill those gaps by purchasing apps from Independent Software Vendors (ISV). Most ISVs are motivated by the need to make their products work against multiple database platforms, which makes specialized and high-performance code more difficult, in addition to their desire to get products to market quickly. So, what are the metrics and instrumentation that a SQL Server pro can use to determine overall quality of such products without doing lengthy code reviews? The good news is that it’s possible to gauge the overall quality of a purchased app by looking at a short list of PerfMon counters, wait statistics, and DMV queries. In this session, we’ll reveal the analysis required to rapidly determine vendor product quality and their adherence to best practices around software and database development.
Kevin Kline is a database expert and Technology Evangelist at SQL Sentry, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin's best known book is the best-selling "SQL in a Nutshell" and contributes monthly for Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/KevinKline.