SqlServer-QA.net

How many tools do you (need/use0 to monitor the performance of your SQL Server instance(s)? Well, I'm not asking any count on the x number of tools you require to monitor the SQL Server instances within your environment, and Performance Tuning using Management Studio unlike any other tool to figure out to monitor the performance tuning. ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2008 EnterpriseNotification Contents: New and Major Modifications SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pageshttp://support.microsoft.com/kb/955628/en-US

The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit  based servers. This is a operating system based privilege that is required by SQL Server service account to allow locking of physical memory ...

What kind of performance issues you see on day-to-day basis within your environment? The following elements are important factors that can add fuel to the fire (problem): Faulty hardware • Hardware that is not configured correctly • Firmware settings • Filter ...

This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if  there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around, then there is usually no reason to set any restrictions on the server ...

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version).  Not only this there will be more questions asked related to general guidelines or any other setup ...

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

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand.   Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands the database when additional space is required. Internally within ...

Until last month I was not  aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may encounter when you use Volume Shadow Copy Service (VSS) enabled backup applications. SQL ...

As a programmer interacting with SQL Server's cache is not often needed, but when you do need to determine what is going on with the cache, or you simply need to flush the execution plans or data pages to tune a query, you now have the means to do so. Below is the TSQL I have used to obtain buffers that are used within memory by object (SQL ...