Content deleted Content added
→SQL Server 2000: First version of Itanium builds. |
→SQL Server 2005: x64 |
||
Line 164:
SQL Server 2005 introduced DMVs (Dynamic Management Views), which are specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.<ref name="Dynamic Management Views and Functions">[http://msdn.microsoft.com/en-us/library/ms188754.aspx Dynamic Management Views and Functions. retrieved June 6, 2010]</ref>
SQL Server 2005 was the first version with native support for the [[x86-64|x64]] platform.<ref name="The Definitive Guide to Scaling Out SQL Server 2005">{{cite book|url=https://books.google.com/books?id=MhkaNTEGCdgC&pg=PA218&lpg=PA218#v=onepage&q&f=false|title=The Definitive Guide to Scaling Out SQL Server 2005 Edition|author=Don Jones|publisher=realtimepublishers.com}}</ref>
Service Pack 1 (SP1) of SQL Server 2005 introduced Database Mirroring, a high availability option that provides redundancy and failover capabilities at the database level.<ref name="database mirroring">{{ cite web | url = http://support.microsoft.com/kb/907741 | title = Issues to consider when you use the database mirroring feature in the initial release of SQL Server 2005 | publisher = Support.microsoft.com | date = 2007-11-20 | accessdate = 2011-09-04 }}</ref> Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety).<ref name="Automatic Failover">{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms189590.aspx | title = Automatic Failover | publisher = Msdn.microsoft.com | accessdate = 2011-09-04 }}</ref> Database Mirroring was included in the first release of SQL Server 2005 for evaluation purposes only. Prior to SP1, it was not enabled by default, and was not supported by Microsoft.{{citation needed|date=June 2015}}
| |||