SQL Profiler is a tool that allows the application and database developer to troubleshoot general SQL locking problems, performance issues and perform database tuning.

DiscountASP.NET, a Windows hosting provider, announces  enhancing its SQL Server hosting with the launch of SQL Server Profiling as a service. The company claims that SQL Profiler is a powerful tool that allows the application and database developer to troubleshoot general SQL locking problems, performance issues, and perform database tuning. It says that the SQL Profiler captures all of the SQL queries and the CPU/IO usage associated with a statement that is issued to the database.

The company further states that with this service, a standard trace will be run at a time specified by the customer and the trace file will be made available for download. The customer can then analyze the trace file using SQL Profiler or Database Tuning Adviser on their local computer.

"While many SQL development issues can be diagnosed on a customer's development environment, there are issues that only crop up in a production environment and perhaps only at specific time of the day. These issues can be very difficult to troubleshoot," said Takeshi Eto, VP Marketing and Business Development at DiscountASP.NET. "With our SQL Profiling as a Service customers can schedule a database trace at a specific time of their choosing and offers a new way to help our customers troubleshoot."