Solved

Optimize for adhoc workloads

Posted on 2011-03-18
2
293 Views
Last Modified: 2012-06-27
Hello,

Optimize for adhoc workloads is a new feature for SQL SERVER 2008.
What is the same option for SQL SERVER 2005?

Thanks

Regards

bibi
0
Comment
Question by:bibi92
2 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 35171831
if by => "Optimize for adhoc workloads is a new feature for SQL SERVER 2008"
you mean the RESOURCE GORVANOR then no you dont.

but bear in mind that the resource gorvanor dosent realy optimize ADHOC but only distributes the resources on the system between pools and groups to minimize the efect of Heavy ADHOC.
0
 

Author Closing Comment

by:bibi92
ID: 35172507
Thanks bibi
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question