MS SQL DB: SQL statement /index tuning

[waelkensd]

Dear community,

I've been dealing with Oracle performance issues lately and was able to tackle them with the use of the  RSORASTT tool (described in note http://service.sap.com/sap/support/notes/1299493)

I was looking for some guidelines (blog, or document ) on how to interprete sql statements on ms SQL DB's and troubleshoot performance issues.

In orde to do this on Oracle you can check the buffer gets for example to see whether there are any performance issues on the specific query. Is there anything in ms sql as well which is an instant indicator a query is not performing as it should?

Thanks in advance for your suggestions

Dieter

[former_member211576]

Hi Dieter,

  I solve all SAP on SQL query performance by using DBACockpit only. However, if you need more in deep  knowledge, you can also check these links.

http://blogs.msdn.com/b/saponsqlserver/archive/2009/02/09/sql-execution-plans-part-1-sql-statement-e...

http://blogs.msdn.com/b/saponsqlserver/archive/2009/02/22/sql-execution-plans-part-2-sql-compilation...

https://blogs.msdn.com/b/saponsqlserver/archive/2009/05/10/sql-execution-plans-part-3-how-to-get-the...

Troubleshooting Performance Problems in SQL Server 2008