Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 28, 2007

Measure TSQL Statement Performance

By DatabaseJournal.com Staff

[From SQL Server Performance]

How do you determine how well your application is performing? What tools can you use? Every developer needs to make sure that each application TSQL statement is optimized. By tuning each query you can make sure that your application is running as efficient as possible. It is much easier to make modifications to application code while you are working in a development environment. Once your code is in production making modifications to optimize your code might take a long time, or even be impossible. This is why you need to review your application code performance periodically during the application development process. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.

The article continues at http://sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM