SQL Servers manage application data in terabyte size. Application security, stability and performance are heavily dependent on the availability and throughput of simultaneous access to the database instances.

The architecture inside the Microsoft SQL Server allows for the operation and management of one or more databases with only one server process (Win32 Service). This permits the separation and management of various applications or business divisions with only one SQL Server.

Every database consists of data files and transaction log files that are combined in data groups. The Microsoft SQL Server requires four system databases for the management of internal system information and parameters regardless of user and application databases where the actual usage and application data is stored.

The SQL Server centrally manages all client-sessions, enquiries and memory buffers.

Various and altogether independent Microsoft SQL Server 2000 instances can operated on server systems that provide the necessary size and speed.

All objects mentioned above have to be permanently monitored and analyzed in order to guarantee full availability and performance.

The following attributes are monitored and analyzed in detail:

• database status
• database availability for clients
• disk space requirements of data and transaction log files
• automatic enlargement of data and transaction log files
• changing of database configuration parameter
• transactions per second
• cache hit rate

In addition to this, various database values and configurations can be directly displayed in lists.

theGuard! ApplictionManager includes pre-configured thresholds for the monitoring of SQL Server.

• availability, performance and analysis of Microsoft SQL Server systems and applications running on SQL Server
• capacity planning and control
• storage optimization