Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.