Microsoft Advisory Services Engagement Scenario – SQL Server Performance
Symptoms
Note: This article discusses a scenariothat may beaddressed by Microsoft Advisory Services.
Microsoft Advisory Services is an hourly fee-based, consultative support option that provides proactive support beyond your break-fix product maintenance needs. This is a remote, phone-based support option that includes working with the same technician for assistance with issues like product migration, code review, or new program development. This service is typically used for shorter engagements, and is designed for developers and IT professionals who do not require the traditional onsite consulting or sustained account management services that are available from other Microsoft support options. This article also provides some self-help resources for this scenario.
For additional information on Microsoft Advisory Services, including on how to engage, refer to this Microsoft web page:
http://support.microsoft.com/default.aspx?pr=AdvisoryService(http://support.microsoft.com/default.aspx?pr=advisoryservice)
Resolution
Microsoft Advisory Services does not guarantee identification of root cause.For example, if adding an index, updating statistics,or applying a Cumulative Update (CU) resolves the issue, Microsoft Advisory Services is not obligated to continue troubleshooting to determine customer specific root cause.If at the request of Advisory Services personnel, you are willing to continue troubleshooting to identify root case, you will not be charged for the additional hours. You may be asked to upgrade to the latest build (CU) of SQL Server for their Service Pack and activate certain fixes.Ifyou are unable to upgrade to the latest CU or activate fixes, working on your issue may be postponed.If upgrading to the latest CU fixes the problem, the case will be marked as “bug related” and you will not be charged.