Comments
Sort by recent activity
@Alex B, This worked perfect. Thanks a lot for the solution! Kind regards, Thomas / comments
@Alex B, This worked perfect.Thanks a lot for the solution!Kind regards,Thomas
Hi @Victoria W , Logging in as the service account running SQL Monitor is not an option as this will flag a lot of stuff on our security monitoring. / comments
Hi @Victoria W ,Logging in as the service account running SQL Monitor is not an option as this will flag a lot of stuff on our security monitoring.
purplesoup said:
Fabulous! So it looks like if I had 1000 SQL statements I would only have to look at the warnings to filter out the ones that were performing badly?
Are the warnings themselves written to a SQL table so I can query and filter them?
I guess the thing to do is download the trial version and see how I get on...
Be aware that suggested indexes will only improve that specific query. SQL Monitor just uses the information available in the query plan. The index proposal you see will be exactly the same as the one in SSMS. Indexes improving one query could slow down other operations. Be aware on adding indexes without testing thoroughly. Also, depending on the database, not all software vendors support index tuning on their database. Future upgrades or changes could fail if you start fumbling around in the indexes. / comments
purplesoup said:
Fabulous! So it looks like if I had 1000 SQL statements I would only have to look at the warnings to filter out the ones that were performing badly?
Are the warnings themselv...