Browse by Tags

All Tags » sql server » memory   (RSS)
SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   
In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...
SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?
17 April 08 03:06 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server problem: Excessive paging and memory bottlenecks
16 April 08 12:02 AM | SQL Master | 2 Comments   
Paging and Memory bottlenecks are quite common when a performance problem strikes on your SQL Server. As we discussed here previously and relevant blog posts below talks about them: Paging and Available Memory for Operating sysem, what you need to know? Read More...
SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?
04 April 08 02:48 AM | SQL Master | 3 Comments   
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, Read More...
SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
01 April 08 02:49 AM | SQL Master | 5 Comments   
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 Read More...
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.
07 March 08 03:54 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server 2005 memory configuration gotchas
28 December 07 03:44 AM | SQL Master | 5 Comments   
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 Read More...
More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
23 August 07 02:33 AM | SQL Master | 3 Comments   
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...
sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
17 August 07 06:04 AM | SQL Master | 3 Comments   
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...
/3GB /PAE and AWE blurb what is it you hear within your environment?
25 July 07 07:06 AM | SQL Master | 4 Comments   
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...
Why query execution timeout happens and find queries that have granted memory or waiting on memory?
23 July 07 02:44 AM | SQL Master | 1 Comments   
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...
SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file
13 July 07 03:25 AM | SQL Master | 1 Comments   
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 Read More...
A significant part of SQL server process memory has been paged out. This may result in a performance degradation
06 July 07 01:40 AM | SQL Master | 2 Comments   
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 and you can Read More...
Handling and troubleshooting memory issues in a SQL Server 2005 instance
19 June 07 02:29 AM | SQL Master | 2 Comments   
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 Read More...
How to find dirty buffer pages and clear them - SQL Server
21 May 07 08:22 AM | SQL Master | 0 Comments   
Dirty buffer pages are nothing but consuming more memory for even smaller queries on the SQL Server. By default the DBA shouldn't worry about these dirty pages in the buffer pool as they are taken care by the system using Write Ahead Logging ( WAL )method. Read More...
More Posts Next page »

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication