Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Foglight for SQL Azure 5.5.8.6 - User Guide

Introducing Foglight for SQL Azure Adding and Configuring Agents Reviewing SQL Azure Activity Reviewing Database Usage Reviewing the Database Properties Monitoring Estimated Costs Viewing User Metrics Using the Global Administration Options Reviewing Foglight for SQL Azure Alarms Glossary

Stolen pages

Pages “stolen” from the buffer pool to be used for miscellaneous server purposes, when Windows requires memory for another application. A large number of stolen pages may be normal for a short period (for example: if the system backup begins after large database batch run completes). However, constantly high value of this metric may indicate an overall system memory shortage.

Stored procedure

A series of Transact-SQL statements, stored as an object within a SQL Server database, that can be called (executed) by SQL Server sessions with appropriate permissions.

Temporary tables and table variables

Temporary tables are tables created in the tempdb database. These tables are session-specific tables, namely: even though they are backed by physical disk and logged into the transaction log, the tables are automatically dropped when the session is closed. As a result, temporary tables are usually not written on disk, but only saved in the procedure cache memory.
Table variables, on the other hand, are created in the memory and exist there until the running of a single Transact-SQL (T-SQL) batch is completed. Unlike temporary tables, they do not require locking and are less I/O-intensive.

Threshold

A range of values that may be returned by a metric. If the metric falls within this range, Foglight for SQL Azure checks the threshold's severity to determine how to behave. For example, the component representing this metric might change color.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation