Microsoft SQL Server includes the SQL profiler, a powerful tool for improving the performance of database applications. If your application is running slowly, most likely you can't solve the problem by looking at the application alone, or the database alone. Instead, you need to understand how the application interacts with the database. SQL Server Profiler allows you to understand these interactions and will show you where to look to improve application performance.
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering full spectrum Microsoft SQL Server Services in North America. He has authored numerous articles publishes white papers on various SQL Server topics, serves as an "Ask the Expert" at www.SearchDatabase.com and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. He is the author of the Start to Finish Guide to IT Project Management which has been will received in the IT community. Jeremy holds a Master's Degree in Information Systems from The University of Maryland, Baltimore County.
Jeremy Kadlec can be reached at jeremyk (at) edgewoodsolutions.com.