What about the SQL SERVER 2008
| SQL SERVER 2008 have some beautifull features over its previous version some of these are as follows:-
(1)Its take less resources and better performance. (2)Its contains Extended Events which are low level and high performance eventing system in SQL SERVER.(3)New Extended Events are based on ETW(Event Tracing for Windows) which helps in SQL tracing to trace oPerating System,IIS and other ETW enabled applications. (4)Event that are fire i |
|
| n SQL 2008 are very fast and fire themselves synchronously and not take too many memory.
(5)One of the good feature is system_health Extended Events Session which is always on and report on any bad data in it. (6)Currently 254 events defined in SQL Server 2008. | |