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
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:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Tested it out myself and yes the stats are counted from an encrypted stored procedure if anyone else is looking for the answer.