SqlServer-QA.net

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh.   In addition to this when you talk about files intialization you must consider the hardware such as RAID, as the software data block ...

One of the recent usergroup meeting brought an interesting question that ''what type of hardware I need for a RAID-5 Shared Array for SQL Server Cluster''?By default RAID5 hardware controller is best to hold as not to go with software RAID5 as it will be single-point-of-failure. When you talk about RAID5 on hardware then by default you'll need an ...

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information you need to consider that one of the reason behind slow indexes process or rebuilding ...

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