Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If a stored procedure in SQL Server 2005 is created with the syntax "WITH ENCRYPTION" ,are the reads and writes of the encrypted stored procedure recorded in the sys.dm_db_index_usage_stats? I am calculating reads by using the user_seeks + user_scans + user_lookups columns and the writes by using the user_updates column of this DMV. Thanks

share|improve this question
Why wouldn't they be? – Remus Rusanu May 21 '13 at 13:35
Encryption hides the SQL text of the SP when running just wanted to make sure it was not hiding anything else. – kdis May 21 '13 at 14:02
up vote 0 down vote accepted

Tested it out myself and yes the stats are counted from an encrypted stored procedure if anyone else is looking for the answer.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.