Yes, good script. But what its practical usage ? Yes, I found that for most of my tables read ratio is 95%, and what next?

I did not find compression option. It would greatly save your space.

By some reason RPC:Completed does not work for me, probably I am doing something wrong.

I need to filter the trace. Without it, my trace will be flooded with millions...

I also trace host name and login name. Most of the calls come from one of the two app servers, and some calls from a job scheduler (not SQL Server...

Yes, it's for debugging. If it's impossible with trace, what other means can I use? Will extended events or reading transaction log give me these values?

Now I got it. Thanks.

How I can get to Replay Configuration dialog box ? Is it in Profiler? My version is 2008 R2 and I don't see it anywhere.

Replay menu has only this items:...

Good scripts.

Couple of notes:

1. Besides D and L types of backup, there is also P = partial.

2. It would be also helpful to include database_name in select part of "Most...

where .....

and is_snapshot=0

You can increase MAXTRANSFERSIZE and BUFFERCOUNT parameters.

But test before applying to production. I set my maxtransfersize = 4194304 and buffercount = 400 and it reduced backup time by 30-40%.

You...

Do you mean an installation file with extension *.msi ? I don't have one. I downloaded .exe file from MS site: SQLServer2014Documentation_August2014_EN.exe.

If I run it, it creates set of 12...

Thanks a lot!

Now I have all B.O.L.

Thank you very much! Finally I could install it.

But I have an impression that it's incomplete. In Index section, I tried lag, lead, last_value - it did not have them....

If I click Help/Manage Help Settings, I receive an error "You do not have permission to modify content under the location specified for the help content store".

If I click OK,...

"The company" means your client organization or your own company?

If you travel for your client business, it should have been stipulated in the contract.