SqlServer-QA.net

Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as MSDN blogs, Books Online and articles, frequently viewed concept for memory is such as ...

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct attach storage.   The important factors such as virtualization of physical disks, RAID ...

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

Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write activity, it is not as important to be concerned with the subject of disk I/O and balancing of SQL ...

Utilizing RAID is beneficial to both the security of your data and the performance of your shop -- but at the same time is very challenging to understand.Cut through the confusion with the new RAID Handbook from SearchStorage.com. Access 3 new RAID tips and get insight into:* The status of RAID and it's relevance in today's storage ...