-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Star_Venkat
Message 1 in Discussion
DBCC:
Database consistency checker is the functionality used to display insight of a
table or database objects. It enables a multipurpose functionality like
maintenance of the database
providing information about the database and validation operation to be done on
database.
To display the Cache information:
Below is the command used to display the cache related information.
DBCC PROCCACHE
The above query will retrieve,
1. The number of proc buffers located in your database,
2. Number of Proc buffers used,
3. Number of Proc buffers Active,
4. Proc cache size,
5. Proc cache used,
6. Proc cache Active
Regards,
Venkatesan prabu. J
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
