Category: MSSQL

0

MSSQL How long will data be in cache/buffer

How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in the cache. Witch the...

0

MSSQL – See buffer hit ratio

Whit this code, you can see how much of query in percent at this moment is reading from the cache/buffer. Share this:

0

See if a database is using Enterprise features of an Microsoft SQL server.

Run this command to see if any database on the SQL Server is using enterprise features

  Share this:

0

MSSQL see witch user that have SysAdmins access

WIth this command you can see witch user that have SysAdmins access.

  Share this:

0

MSSQL Databases

To show all MSSQL databases except the normal system databases.

  Share this:

0

MSSQL Free Space in Databases files

To get a list of the databases files, and the current disk size in MB, and the Free Space in MB in each fil, you can use this commands

Share this: