SqlServer-QA.net

It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though.   X64 computing platforms have become common installations now a days due to the hardware reduced costing and availability, at the same time the DBA will have big job to tune the platform in terms of ...

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

You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and writes from the database to disk. In this case take help of SYSMON (PERFMON) for Avg. Disk ...

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

Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real ...

TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's  memory &  processor are coping up. Though they give initial picture of usage it is always better to go through by SYSMON ...

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of the reason that memory has been a constraint on scaling-up server capacity. Once you consider ...

Long ago, not long ago.... No doubt that many of you might have gone through the error above within your SQL environment, also I see many forum posts out there to resolve the issue. The bottom line of this issue is Hardware and no other issue can contribute such a problem. So this is where DBA's role is enhanced to take care of ...