Browse by Tags

• /3gb
• 32 bit
• 3gb
• 64 bit
• analysis
• Analysis Services
• awe
• bad
• blunders
• buffer pool
• clr
• cpu
• cube
• database
• disk space
• disks
• dmv
• edition
• enterprise
• execution plan
• Hardware
• instances
• kba
• lock
• long running
• managed code
• management
• Microsoft
• MSDN
• notification
• pae
• pages
• paging
• performance
• process
• query
• schema
• script
• security
• server
• shrink
• SQL Server
• ssis
• SSMS
• system
• tsql
• windows
• x64

• A funny thing happened on the way to the database

  A funny thing happened the other day. I was running 64-bit Dev edition on my 4Gb Vista 64-bit notebook. SQL Server was set to 1Gb RAM and I was running 10 scripts each continually inserting a new randomly generated person into a table. The goal was to Read More... Posted Saturday, December 15, 2007 3:20 AM from Paul Nielsen | (Comments Off) Filed under: memory, blunders

• How to reduce paging of buffer pool memory in the 64-bit version of SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications How to reduce paging of buffer pool memory in the 64-bit version of SQL Server Read More... Posted Thursday, August 30, 2007 4:09 AM from SSQA.net | (Comments Off) Filed under: SQL Server, x64, memory, kba, buffer pool, paging

• While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

  Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is available Read More... Posted Monday, August 27, 2007 8:47 PM from SSQA.net | (Comments Off) Filed under: Analysis Services, SQL Server, performance, memory, server, process, cube

• More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.

  Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise Read More... Posted Thursday, August 23, 2007 7:33 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, edition, awe, pae, memory, windows, instances, 3gb, enterprise

• FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program”

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a SQL Server 2005 Integration Services package that Read More... Posted Tuesday, August 21, 2007 5:41 AM from SSQA.net | (Comments Off) Filed under: SQL Server, script, memory, ssis, kba

• sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

  The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any Read More... Posted Friday, August 17, 2007 11:04 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, SSMS, memory, cpu, dmv, analysis, disks

• 32bit vs 64 bit what other factors you need to consider?

  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 Read More... Posted Tuesday, August 14, 2007 11:16 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, x64, memory, server, windows, 32 bit, system, 64 bit

• Why 64-bit SQL Server been slow during query performance?

  As usual for every performance issue there are many considerations that need to be evaluated when determining how to investigate the root cause for slower performance of many SQL Server databases. I would suggest that an important consideration is whether Read More... Posted Saturday, August 11, 2007 7:34 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, x64, memory

• Performace overhead and resolution when using CLR vs TSQL

  Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds Read More... Posted Tuesday, July 31, 2007 6:42 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, tsql, memory, server, clr, managed code

• /3GB /PAE and AWE blurb what is it you hear within your environment?

  You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From Read More... Posted Thursday, July 26, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, Microsoft, management, awe, /3gb, pae, memory, server, windows

• Does DBCC SHRINKFILE consumes operating system resources such as memory, CPU usage etc.?

  Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to the server. But think about performing the SHRINK operation of transaction log & database files on regular basis, say within a scheduled job or ongoing Read More... Posted Wednesday, July 25, 2007 7:30 PM from SSQA.net | (Comments Off) Filed under: SQL Server, database, memory, cpu, shrink, disk space

• "A significant part of sql server process memory has been paged out. This may result in a performance degradation." - what it is about?

  As you might come across this BlogPost here but still there are more doubts to be cleared on the reasons for granting Lock Memory in Pages option to the SQL server instance. There is still lot of confusion over there to check whether lock memory in pages Read More... Posted Tuesday, July 24, 2007 6:25 PM from SSQA.net | (Comments Off) Filed under: security, performance, MSDN, memory, schema, lock, pages

• Why query execution timeout happens and find queries that have granted memory or waiting on memory?

  Have you ever identified the reasons for why and how does a query execution timeout happens within your SQL Server environment. For the beginners I would like to explain that b efore executing a query, SQL Server estimates how much memory it needs to Read More... Posted Monday, July 23, 2007 7:44 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, memory, dmv, notification, execution plan, bad, long running