What’s in Enterprise only? (Fast Recovery)

During a crash recovery or a database mirroring failover, SQL Server Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which behave exactly like the Enterprise does. The only difference among them three is their licensing.) let users access the database before the full recovery process finishes (i.e. after the redo phase…

0

How true is it that Missing Indexes feature cannot gather stats for more than 500 missing index groups?

Not much, really. There is a topic in SQL Server’s documentation about the Limitations of the Missing Indexes Feature. In this post, I want to discuss about the one limitation enumerated in that list, included in the referred topic, where it describes the theoretical existence of a maximum of 500 missing index groups. The missing…

0

What’s in Enterprise only? (up to 2TB of memory)

Beginning with SQL Server 2008 R2, there’s a significant difference in the amount of memory that SQL Server can allocate from the OS to its buffer cache (Buffer Pool). An Standard Edition will not grow it further than 64GB, no matter how much physical memory is available to the system on which the instance of…

4

What’s in Enterprise only? (Backup Mirroring)

Increasing the reliability of your backups by providing redundancy is something you can achieve with SQL Server’s mirrored backups, which is an out-of-the-box feature available only in the Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which behave exactly like the Enterprise does. The only difference among them three is their…

0

Never ever set up a Database Mirroring session across different SQL Server Editions (SKU)

Even though it might work, never attempt to do that. As the documentation clearly states: it is unsupported. In topic Prerequisites, Restrictions, and Recommendations for Database Mirroring, Books Online shows a Prerequisites section where it mentions the following: Prerequisites Before you can set up database mirroring, you must perform the following: For a new mirroring…

3

Launching Database Mirroring Monitor without having to go through SSMS

Yesterday, while co-delivering a seminar on Database Mirroring to a few customers, one of them asked whether it was possible to open Database Mirroring Monitor in an easier, more straight forward way than having to open SQL Server Management Studio, connecting to one instance, expanding the Databases node, right clicking on one of the databases,…

0

What’s in Enterprise only? (Online Restore)

If you want to have the possibility to restore data on a database while it is already online (i.e. whenever its primary filegroup is online) you can do so only if you are running the Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which behave exactly like the Enterprise does. The…

0