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.
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!
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
15 People are following this question.
