?
Solved

Optimize for adhoc workloads

Posted on 2011-03-18
2
Medium Priority
?
321 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 2000 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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 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