[ARCHIVED THREAD] - SQL Server question

Posted: 4/28/2015 3:34:20 PM EDT

We have Microsoft Dynamics as our business software. It's data is stored in a SQL Server 2008 database. I am wondering if there is some why I can tell if queries are being run against the DB on fields the should have indexes but do not. So I can create these indexes and hopefully improve the performance of this system.

Posted: 4/28/2015 4:51:27 PM EDT

[#1]

You need to check the performance tools that will show you the query plans for your stored procedures and queries.
The query plan will tell you the index (or none) being used for each join/where/sort of the query.

Posted: 4/28/2015 9:26:33 PM EDT

[#2]

Quote History

Quoted:
You need to check the performance tools that will show you the query plans for your stored procedures and queries.
The query plan will tell you the index (or none) being used for each join/where/sort of the query.

View Quote

This.

Posted: 4/29/2015 8:34:16 AM EDT

[#3]

Thanks I will check this out.

[ARCHIVED THREAD] - SQL Server question

Warning

Confirm Action

[ARCHIVED THREAD] - SQL Server question

[ARCHIVED THREAD] - SQL Server question