Slow performance calling stored proc

  • Thread starter Thread starter Albert
  • Start date Start date
A

Albert

What could be causing sudden slow performance calling a
stored procedure that normally runs okay?

Thanks.
 
Without any more details than that, it would be impossible to say for
certain. However, the following can all be culprits:

1. Additional load on the SQL Server;
2. Additional load on the database in question;
3. Locks on the resources required by the stored procedure;
4. Slow network performance returning data;

You need to narrow down the problem using SQL Profiler tracing to determine
if the SQL Server is running the procedure slowly, or if the problem is
elsewhere (like on the network or the client).

The following Microsoft Knowledge Base article may be of assistance:

298475 HOW TO: Troubleshoot Application Performance Issues
http://support.microsoft.com/?id=298475

Hope this helps!

Steven Bras, MCSD
Microsoft Developer Support/Data Access Technologies

This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft Security Announcement: Have you installed the patch for Microsoft
Security Bulletin MS03-026?  If not Microsoft strongly advises you to
review the information at the following link regarding Microsoft Security
Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or to
visit Windows Update at http://windowsupdate.microsoft.com to install the
patch. Running the SCAN program from the Windows Update site will help to
insure you are current with all security patches, not just MS03-026.
 
Back
Top