Hello
We got third party software, we are using adhoc queries more for the Applications (i am checking the DB Dashboard, it is showing as 97% CPU for adhoc queries). Could any one suggest how to tune SQL Server (at server level) for adhoc queries, we can not change the code now.
Let me know how to improve the SQL Server, whenever 3rd party applications use adhoc queries more?
Thanks in advance.
You can use DTA for this.
http://msdn2.microsoft.com/en-us/library/ms186354.aspx
You will want to use sql profiler to capture a trace/workload for DTA.
No comments:
Post a Comment