One more question i know the configuration file doesn't store the Username and Password information of the connection string but i guess if u select the option Encrypt sensitive data...
One more question...I have a query with high number of statement executions but i believe the query is not stored in cache....How do i make sure that query is stored...