Thanks Mike?Grant and Jeff for you kind  help !

I tested it with linked server and openquery and found it there was no any improvement in the performance.   but  I found...

do you mean    the reports--> standard reports  for each database , such as: all transactions , all blocking transactions ....?

If yes, do these reports just reflect the resources usage...

Anyway , Erland Sommarskog , thank you for your kind help !

if so, can we understand it as below ? thanks

1. first, create connection, then create session, finally create request?

2. one connection maybe includes more than one session and one session...

Thank you Jeff Moden kind's help!

your post is very valuable and helpful!

Thank you Erland Sommarskog kind help!

Yes, Fetch is also a T-SQL Statement, and fetch is used for a cursor, and I just now to know which select statement  is associated...

Thank you andreas.kreuzberg,  I created a new user and set those permissions as you mentioned then it works fine.

before a created a user like this one and I set all...

Thanks Joe Torre and ZZartin kind help and patience !

yes, I know there are some information in sys.dm_db_index_usage_stats, but how to evaluate this index is useful or useless based on the information of sys.dm_db_index_usage_stats? and is there any other...

Thank you Erland Sommarskog for your kind help! and waiting some experts for detailed explanations.

there are many confusions for me aside from ones mentioned above. when thoese stored procedures called,...

Many Thanks  Grant Fritchey  and MVDBA !

ok, thank you Grant Fritchey!

Thanks  Grant Fritchey and  MVDBA!

if I use transactional replication or  to fulfil this requirement (sync data from OLTP database into OLAP database), how about the latencey of them?  thanks

one more question of Extended Event of SQL Server 2008,  I used the following scripts to  generate the captured files in SQL Server 2008, how can I read these files...

Thanks MVDBA and Grant Fritchey  for your time and good advice.

Very Sorry for no repond for a long time!

We have one ERP system, one SQL Server database is an OLTP...