question

MAXKA avatar image
MAXKA asked

Downgrade SQL server 2008Enterprise RTM to SQL server Standard edition

Hello, we have got a project where , seems from cost point of view, need to downgrade the servers from enterprise to standard, one which are applicable. Now, here is this server which act as repository server only for Idera Diagnostic manager and Idera SQL Safe.Thus we have reportserver DB's and repository databases for those two products on this server. I used `select * from sys.dm_db_persisted_sku_features`to find any ent features used by these databases, but could not find one. So we are hoping we should be good to proceed. Before proceeding, i would like to know the check-list to be handy before moving ahead and the best way of doing so! Thanks in advance.
sql-server-2008sql-serverdowngrade
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
I would suggest contacting Idera support for confirmation but in looking at their system requirements it does not state anything about needed Enterprise for either product. https://www.idera.com/productssolutions/sqlserver/sqldiagnosticmanager/systemrequirements https://www.idera.com/productssolutions/sqlserver/sqlsafebackup/systemrequirements If those are the only two databases (other than system ones of course) located on that instance, I would suspect that you are good to proceed. Towever I'd follow up with them to be sure. I'd also take this time to consider consolidating the databases to another instance. Even with standard edition licensing, you could save more if consolidate down, if the hardware will support the additional workload. Just a thought. Hope that helps!
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi, Idera works on Standard if that is what you are asking. The only limitation would be SQLs limitation (i.e. CPU & RAM). But in my past life, you would need to be monitoring large number of instances. But as @JohnM has covered, react out to Idera for a sizing guide. IMO, 4 CPU and 64GB should be good for well over 100 instance
1 Like 1 ·
Thanks @JohnM, i will reach Idera with that. Also do you have any best practices/check list to execute the plan. Thanks
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.