(Ratings: 0   Avg: )
Rate It!
Share It!

Identifying queries running slower than normal

A query can start to run slower for many reasons, including: an increased number of users (resulting in more waiting on resources), increased volume of data to process, too much context switching for parallel queries, and slower hardware. When a query is run, its query plan is cached to improve subsequent run of the query. Many interesting details relating to the query are recorded, these details can be accessed via SQL Server’s Dynamic Management Views (DMVs). In particular the DMV sys.dm_exec_query_stats contains performance statistics for cached query plans. This DMV has everything we need to determine if a query is running slower than normal.

 

Read the rest of entry »

Quality Metrics

Following Metrics will be used to assess the project health.

Read the rest of entry »

Custom Document Property as Page Title

This blog is tip about changing the default title for web part pages

Read the rest of entry »

Including custom JavaScript files & Adding events on fly in MSCRM 3.0

Including custom JavaScript files & Adding events on fly in MSCRM 3.0

Read the rest of entry »