I want a script which is plain and simple to understand. I would prefer using plain TSQL Also, looking if someone is using similar one, I want to reuse it....

Any suggestions please.

Thanks Jeff, for sharing your thoughts. I have never thought in such a way. Perhaps, need to do a testing with a proper example to get some hands dirty on...

Hi Carsten,

Many thanks for sharing the scripts.

Sam

Thanks Jeff Moden. I would try the same on a sub-prod environment. Thats a very good idea.

Hi Jeff,

Thanks for the options provided. One thing wanted to know, will both methods will take of Transaction log reuse right? meaning, rather than log file growing out of proportion...

Its a logging information. We don't need that log history to be maintained.

Thank you Grant & Jeff.

• This reply was modified 4 years, 7 months ago by vsamantha35.

Thanks a lot Brain. Will follow up with the Actifio on this.

Hi Jeff,

How many servers are we talking about here?

2 servers which are specific to one application. Its a 2 node AG cluster.

Even though you mentioned you are an accidental DBA,...

Thank you Tac11 and Imarkun for the inputs.

Best Regards,

Sam

Thank you Jasona and Jeffrey for providing the insights. Many Many thanks.

I pulled the I/O information for this database.

SELECT [database_id],

[file_id],

[num_of_reads],

[num_of_bytes_read],

[io_stall_read_ms],

[num_of_writes],

[num_of_bytes_written],

[io_stall_write_ms],

[io_stall],

[size_on_disk_bytes]

FROM sys.[dm_io_virtual_file_stats](NULL, NULL)

where [database_id] = 12

ORDER BY [io_stall] DESC;

GO

I completely agree with you Jeff. Thanks for those suggestions.  We have identified the top I/O queries  (using various dmvs based on query_hash , dm_io_virtual_file_stats) and provided to the DEV...

The TDE encryption took about 48 hours to complete for a 4.5 TB database.

Post encryption, we are seeing some issues with log backup generation.

We take log backups every 30 hour....