Database Tuning Advisor “not permitted” error on SQL Server 2005 DE

pts.
Tags:
Database
IBM DB2
Management
Microsoft Windows
Oracle
OS
Security
Servers
SQL
SQL Server
Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of SQL Server 2005 is not permitted." I've searched the net for the problem, but all I find is that DTA isn't available on the Express Edition. But I should be able to use it, shouldn't I? BTW I had to download some file from Miscrosoft in order to get it to work. Some .dll that had to do with xml. Maybe this is the key clue...

Answer Wiki

Thanks. We'll let you know when a new response is added.

I do NOT think the tuning will work with what MS gave developer’s. Tuning is generally something that happens when developer products begin hitting the real world. I suspect that is when Microsoft expects to be paid for allowing production work to actaully begin.

Microsoft likely also thinks: As a developer on your own workstation you really don’t need to tune. If your software is slow before hitting real world test loads on a setup matching an actual production server — you need to rewrite not tune.

Between these development on your own workstation and the prodcution server, Microsoft does sell Universal Subscription Kits and such which provide special developer copies of OSes and server applications. That is you would set up actual seperate servers similar to the production network to do more elaborate testing against. These softwre products are bascially the same as prodcution software and here you would do tuning when you start sending autmated test data design to look like a full load of real users.

I doubt the XML intereface .dll changed the version of SQL you got. The interface components are pretty standard across versions though as you see certain SQL engine versions simply are unable to use certain features even if the interface components are not there.

You may have to contact someone on the MS usenet forums to find out for sure but — I suspect you got the express version of SQL 2005. Something extra for free. The idea being most development works fine with Express yet most production will need a better version.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mortree
    I do NOT think the tuning will work with what MS gave developer's. Tuning is generally something that happens when developer products begin hitting the real world. I suspect that is when Microsoft expects to be paid for allowing production work to actaully begin. Microsoft likely also thinks: As a developer on your own workstation you really don't need to tune. If your software is slow before hitting real world test loads on a setup matching an actual production server -- you need to rewrite not tune. Between these development on your own workstation and the prodcution server, Microsoft does sell Universal Subscription Kits and such which provide special developer copies of OSes and server applications. That is you would set up actual seperate servers similar to the production network to do more elaborate testing against. These softwre products are bascially the same as prodcution software and here you would do tuning when you start sending autmated test data design to look like a full load of real users. -- I doubt the XML intereface .dll changed the version of SQL you got. The interface components are pretty standard across versions though as you see certain SQL engine versions simply are unable to use certain features even if the interface components are not there. You may have to contact someone on the MS usenet forums to find out for sure but -- I suspect you got the express version of SQL 2005. Something extra for free. The idea being most development works fine with Express yet most production will need a better version.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following