Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pushp82
Yak Posting Veteran
83 Posts |
 Posted - 2013-05-27 : 01:15:43
|
| Hi Guys,I have 5 databases on same instance of sql server and all functions and procedures are on one database. I taced the all hits through tunning template in profiler and then PDS as non-clustered index, partition as no partition, keep all existing PDS and selected all my five databases in general tab.but there was no index recomandation for indexes.Please help. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-05-27 : 02:53:56
|
| That is possible. Are you experiencing performance issues on a particular query? Identify the slow query , measure how long it is taking and comapare against how long it should be taking. An alternative to DTA is check the Execution Plans yourself, and identify any sub optimal activity.Also , do you have a solid maintenance plan in place?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
lrosales@shimee.com
Starting Member
3 Posts |
Posted - 2013-05-31 : 13:31:20
|
| First Find out if you have missing indexes, two check for fragmentation, there look for io and locks. avoid the overhead of the profiler. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
No recomandation from DTA for index