4 days

Thanks Grant. However we dont need a complete tracking. Just for few adhoc cases to monitor we needed sometimes the complete log. That helps a lot to write the investigation...

Thank you everyone!!

Getting the results back using the Powershell.

Thank you. After recycle the files gone

Thanks

Not sure why the output results are coming as NULL. Any advise?

declare @linkedserverName sysname= 'server', @DBname sysname = 'db'
DECLARE @dml nvarchar(max)...

Is that case how to find it? DBA's often need to get the details.

Is the below query sufficient to find the encrypted columns?

SELECT stab.name Table_Name, sc.name Column_Name FROM sys.columns sc
   INNER JOIN sys.types st ON sc.system_type_id=st.system_type_id
   INNER JOIN...

Is there anyway I also can check which indexes are doing more writes and which are doing more reads etc?

No change in the procedure script. Wanted to check how a new Execution Plan is created.

I compared the old good and new plan in sql sentry and found that there are missing index recommendation in the new plan. Creating that the index performance is improved.

All indexes stats update says that it was done today. But few days observed high cpu activity while running on a specific proc. Wanted to check how the plan is...

Thanks Everyone for your response. Andrew, Not sure why it skipped my mind. I could not image to cast the databaseproperty area. Spent one hour but kind of was ignoring...