Browse by Tags

All Tags » configuration (RSS)
Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process
Published 21 May 8 4:20 AM | SSQA.net
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...
Filed under: , , , , , , ,
SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?
Published 17 April 8 5:6 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?
Published 4 April 8 4:48 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
SQL Server configuration disk layout - best practices from field
Published 3 April 8 3:17 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
Published 1 April 8 4:49 AM | SSQA.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...
Filed under: , , , , , , , , , , , ,
Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
Published 21 February 8 6:22 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
Relation between SQL Server 2005 and Volume Shadow Copy services?
Published 19 February 8 2:45 AM | SSQA.net
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...
Filed under: , , , , , , , ,
SQL Server 2005 TSQL to obtain buffers by object (table, index) in the buffer cache?
Published 1 February 8 6:30 AM | SSQA.net
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...
Filed under: , , , , , , , ,
Best way to deploy SQL Server 2005 with SAN
Published 28 January 8 2:1 AM | SSQA.net
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...
Filed under: , , , , , , , , , , , , ,
SQL Bits II - here it comes again
Published 13 December 7 5:1 AM | SSQA.net
SQL Bits is back again, this time 01st March 2008 at The Lakeside Conference Centre in Birmingham. Its a bigger venue than Microsoft TVP that will give more people 'SQL Geeks' to attend. Hold on your horses, registrations aren't open yet but...
Filed under: , , , , , , , , , , , ,
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
Published 28 October 7 11:56 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Reporting Services Notification Contents: New and Major Modifications How...
Filed under: , , , ,
How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"
Published 27 October 7 5:50 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete How to install and how to configure SQL Server 2005 Reporting Services on...
Filed under: , , , , ,
How to run Reporting Services 2000 and 2005 on the same server?
Published 8 October 7 3:45 PM | SSQA.net
When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer. Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume...
Filed under: , , , , , , , ,
How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring
Published 8 September 7 4:18 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , ,
Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration
Published 4 September 7 11:41 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Some or all SQL Server 2005 services are...
Filed under: , , , , , , , ,