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 |
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
 Posted - 2008-08-21 : 19:08:36
|
| im trying to use the best index setup on a table. But since there are so many SPs using this table. How do u know which column to index? lets say i have the right indexes on this table and it works fine for 3 SP. But its slow for 4 SP. How do i use the indexes properly to gain performance for the 7 SP? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-21 : 19:18:05
|
| Check out the reports built into Management Studio.Check out the execution plans of the stored procedures.Run SQL Profiler to see what the long running queries are and then add indexes where appropriate.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-21 : 19:25:31
|
| i know how to index. Im just concern about using the right indexes but it would affect the performance from another sp. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-21 : 19:33:51
|
| u dont undestand my question |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-21 : 19:52:03
|
| its freezing cold. how is California? |
|
|
|
|
|
|
perfomance tuning indexes