RE: Performance degrading over time

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 09:38:50 GMT

Hi Tim,

>From your descriptions, I understood that you stored procedures will take
more time to execute until you have you SQL Server restarted. Have I
understood you? Correct me if I was wrong.

Generally, performance issues can be caused by various factors, and it is
difficult to locate the root cause in a newsgroup thread. If the issue
still exists after you have used the troubleshooting steps above, to
efficiently troubleshoot a performance issue, we recommend that you contact
Microsoft Product Support Services and open a support incident and work
with a dedicated Support Professional.

Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

For now, I would like to provide a useful document on how to narrow down
the performance issue with profiler tracing and analysis

HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/kb/224587/en-us

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
 

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Relevant Pages

  • RE: Hung SSIS package is hanging my database
    ... SSIS logging and log providers let you capture details about the package ... connections, it might be some internal errors in SQL Server, To find out ... has to be done by contacting Microsoft Product Support Services. ... Microsoft Product Support Services so that a dedicated Support Professional ...
    (microsoft.public.sqlserver.dts)
  • RE: Configuration parameter in SQL database
    ... Welcome to Microsoft Newsgroup Support Service! ... how to store&return the configuration ... SQL Server + SQL Dependency Cache ...
    (microsoft.public.dotnet.general)
  • RE: Distribution Agent fails with error: Line 1: Incorrect syntax near ,null,
    ... that you open a Support incident with Microsoft Product Support Services ... Information that PSS needs to troubleshoot SQL Server ... Please reply to newsgroups only, ...
    (microsoft.public.sqlserver.replication)
  • RE: Connection Open Exemptions
    ... If the user can log into SQL server using QA, ... The user account can be either Windows account or SQL account. ... that you open a Support incident with Microsoft Product Support Services ...
    (microsoft.public.sqlserver.connect)
  • SQLServer slows down after some time
    ... To troubleshoot this issue, there would be several other things to try and ... Moving SQL Server databases to a new location with Detach/Attach ... The probably cause of the issue is Blocking. ... Support Service, and our support professionals will work on with you ...
    (microsoft.public.sqlserver.server)
Quantcast