in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » Performance » Tools (RSS)

Browse by Tags

  • SSAS 2005 – Server side tracing starter kit

    Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done...
    Posted to Andrew Calvett (Weblog) by ACALVETT on 04-07-2008

  • Indexing Strategies

    I attended the Scottish SQL Server User Group meeting during the week and heard a presentation from Martin Bell on his favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance troubleshooting databases...
    Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-16-2008

  • How many indexes do you have that aren't used?

    If you run this sql on a sql 2005 box then you will see which indexes aren't used in queries compared with the number of times they are updated. select object_name ( s . object_id ) , * from sys.dm_db_index_usage_stats s join sys.indexes i on i . index_id = s . index_id and s . object_id = i . object_id...
    Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 05-16-2007

  • Do you think SSMS is slow?

    Well there are a few reasons for some slowness. One of them is when you display the details of a job. SSMS executes sp_helpjob which returns ALL jobs, even though your only displaying ONE. If you think this sucks then vote now to try and get this fixed. http://connect.microsoft.com/SQLServer/feedback...
    Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-18-2006
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems