Increasing Microsoft SQL Performance

Slow SQL – A Usual Suspect

It's simple, in a development environment, to make any SQL query or app perform quickly. There are two things that have an impact on query performance, both of which typically don't exist in development environments:

1. Data volume

2. User/transaction concurrency

Test environments with more realistic loads and larger data sets can reveal application scalability and performance limits. By showing developers the speed of their SQL queries, development DBAs can earn a lot of their money.

Applications can behave differently - some are write intensive, some are read intensive. Although what can sometimes be a gift for apps teams is adding an index. The DBA has a lot of analyzing and considering to do in order to ensure the schemas are making sense. DBAs have to look for the correct balance of query performance, in order for connected applications to receive the appropriate availability and performance levels.

Applications can be tested in isolation - A developer team tests and optimizes their app against a copied production scale database. However, the dev teams cannot test what impact other apps will have on the shared database - in production. Having one app inefficient in how it accesses the database may create latency for other apps trying to access the same instance.

Applications can be agile - By adopting an agile methodology, DBA, Ops and Dev teams can deliver a competitive edge to their business. But with a lot of change happening, slow performance and application outages are inevitable. AppDynamics can give you the visibility of change and app performance - in production.

Applications can be hidden in production - Production DBAs and devs lack visibility in production and simple application context. Applications are hugely distributed and complex entities. A production DBA will see an app as a type of "connection" that accesses their database, starting from the app server that connects through a connection pool/driver. With each connection there can be hundreds of sessions and hundreds of queries.

Get started in minutes today by with a free trial of AppDynamics for Databases.

"It’s a tool that offers seamless traceability and a view that bridge both the APM and the Business product usage effectively."

Heather Abbott, Senior Vice President of Corporate Solutions Technology, Nasdaq

Related Blogs

AppDynamics Database Visibility adds support for MongoDB

"AppDynamics is proud to announce support for MongoDB within the Database Visibility module. MongoDB was created in 2007 as a commercial product, switching to open source in 2009..."

A Newbie Guide to Databases

"Databases are an incredibly useful tool for storing data. Similar to a library storing books in an organized structure consisting of categories – such as history or art – a database imposes order on your data so that you can quickly construct the information you are looking for..."

Start a 15 day free trial now