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

Had an interesting problem on one of the SANs that will be used to setup a failover clustering installation. The issue error '''There is not enough disk space on the destination disk for the current SQL server data files'' and when I have checked relevant drive there is more 300gb free space avalable. In this case you need to check whether the ...

Security, whether it is for your home or systems you have to be very careful! Ed Gibson, Chief Cyber Security Advisor from Microsoft has articulated very nice article that will talk more about these aspects, we have had a brief meeting with Ed when I was at Microsoft TVP during SQLBits conference. You’ve seen it, read it, heard it so many ...

Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the costs of restoring lost data.This web seminar will explore SAN copy and replication methodologies, in ...

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

Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ''''Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>' is invalid'' suggests that the LSN (log sequence number) passed during ...