What does @@total_write in SQL Server 2005?

Choose one of the answers below:

  1. The total number of writes (disk + cached) for the previous statement.
  2. The total number of writes (disk only) for the previous statement.
  3. The total number of writes (disk + cached) for the instance since last restart.
  4. The total number of writes (disk only) for the instance since last restart.

Answer:

  1. The total number of writes (disk only) for the instance since last restart.

Explanation:

The @@total_read function returns the number of disk writes since the SQL Server instance was last restarted.

No comments:

Post a Comment