Gain control over the growing amount of file data in your enterprise. Learn how File Area Networks (FANs) can help you centralize file consolidation, migration, replication, and failover. Download this eBook and start streamlining your file management projects ....(read more)

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 ...

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT ...

I have gone through a question within the forums asking ''smaller disks or more spindles'' which is better for performance. The simple answer is more disks to handle the data growth and also mostly depends upon the number of transactons that are handled with a sensible normalization, as the transactions method & the CHECKPOINT method are ...