Solved

Optimize for adhoc workloads

Posted on 2011-03-18
2
267 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now