Difference between MSDE and SQL Server 2000
-
S.NoMSDESQL Server 2000
1 Size:
In MSDE database size limited to 2GB.Size:
In SQL Server database size limited to 1,048,516 TB1(1 Billion GB).2Performance:Performance of MSDE degrades when maximum number of concurrent operations greater then or equal to 8. Performance degradation is implemented with the help of SQL SERVER 2000 workload governor.Performance:In SQL SERVER 2000, possible number of concurrent connections are 32,767.3OLAP and Data warehousing:MSDE does not provide OLAP and Data warehousing capabilitiesOLAP and Data warehousing:MSDE provides OLAP and Data warehousing capabilities4Mail:MSDE does not have support facility for SQL mail.Mail:MSDE supports facility for SQL mail.5Administrative Tools:MSDE doesn't have its own administrative tools. There are many third party tools, which provide administrative capability GUI.Administrative Tools:SQL Server have administrative tools such as enterprise manager, Query analyzer or Profiler.
No comments:
Post a Comment