Browse by Tags

All Tags » sql server » performance » memory (RSS)
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: , , , , , , , , , , , ,
SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
Published 7 March 8 4:54 AM | SSQA.net
Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently...
Filed under: , , , , , , , , , , , , ,
SQL Server 2008 Resource Governor FAQ
Published 25 February 8 1:36 AM | SSQA.net
Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...
Filed under: , , , , , , , , , , ,
How to use TSQL to find the size of total and free physical memory within the SQL Server?
Published 24 January 8 4:28 PM | SSQA.net
Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With...
Filed under: , , , , , , , , ,
SQL Server 2005 memory configuration gotchas
Published 28 December 7 4:44 AM | SSQA.net
This may be last post in Performance Tuning & Security blog section here for this year!! Most of this year in the forums & newsgroups I have seen a common question asking about memory configuration within SQL Server 2005. As you may be aware that...
Filed under: , , , , , , , , , , , ,
While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command
Published 27 August 7 5:47 AM | SSQA.net
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...
Filed under: , , , , , ,
More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
Published 23 August 7 4:33 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
Published 17 August 7 8:4 AM | SSQA.net
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...
Filed under: , , , , , , ,
32bit vs 64 bit what other factors you need to consider?
Published 14 August 7 8:16 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
Why 64-bit SQL Server been slow during query performance?
Published 11 August 7 4:34 AM | SSQA.net
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...
Filed under: , , ,
Performace overhead and resolution when using CLR vs TSQL
Published 31 July 7 3:42 AM | SSQA.net
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...
Filed under: , , , , , ,
/3GB /PAE and AWE blurb what is it you hear within your environment?
Published 25 July 7 9:6 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
Why query execution timeout happens and find queries that have granted memory or waiting on memory?
Published 23 July 7 4:44 AM | SSQA.net
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...
Filed under: , , , , , , , ,
SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file
Published 13 July 7 5:25 AM | SSQA.net
By now you should have applied the Service Pack 4 on your SQL Server 2000 instances and you might come across the message within the SQL error log " SQL Server has encountered 5877 occurrence(s) of IO requests taking longer than 15 seconds to complete...
Filed under: , , , , , , , ,
A significant part of SQL server process memory has been paged out. This may result in a performance degradation
Published 6 July 7 3:40 AM | SSQA.net
WIth the recent application of Service pack 2 for SQL Server we tend to see more messages on the log with " A significant part of SQL server process memory has been paged out. This may result in a performance degradation ", its bit confusing...
Filed under: , , ,
Using table-valued functions (TVF) in SQL Server
Published 29 June 7 3:13 AM | SSQA.net
I was looking for more information on Table-Valued Functions (TVF) in SQL Server in attempting to perform sophisticated text analysis using the built-in string functions using .NET. To the subject using regular expressions are not new to SQL. These regular...
Filed under: , , , , , , ,
Handling and troubleshooting memory issues in a SQL Server 2005 instance
Published 19 June 7 4:29 AM | SSQA.net
We had a major issue on one of the SQL Server instance with the memory and getting following error message intermittenlty: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. Eventually I was able...
Filed under: , , , , ,
Using PERFMON to get memory counters, what you need to check?
Published 8 May 7 4:17 AM | SqlServer-QA.net (SSQA)
Refer to AWE if you have enabled the AWE in thsi case. Another piece of advice is if this is not a dedicated SQL Server then make sure you have monitoring MemToLeave information too, as it manage the transaction log requirements. Refer to pages/sec counter...
Filed under: , , ,