When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when it cannot quickly find a page in an existing extent with sufficient space to hold the row being ...

When you run normal SELECT statement from the Activity Monitor, the session has a status of ''suspended'', a command of ''SELECT'' and a wait type of ''ASYNC_NETWORK_IO''. What do you expect to the see the results and within the column status, we will see quite a few requests which are in the status ‘suspended’ and some others as ‘running’. The ...

Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within SQL Server 2005 improves accuracy by using the high-resolution counters that are capable to ...