Browse by Tags

• /3gb
• awe
• best practice
• dbcc
• linked
• management
• max
• max worker threads
• memory
• microsoft
• pae
• query
• resources
• security
• setting
• sql server
• sqlperf
• stats
• system
• testing
• tuning
• wait
• windows
• worker threads

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
15 November 07 08:41 AM | SQL Master | 2 Comments   

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must Read More...

Filed under: tuning, performance, sql server, microsoft, server, dbcc, testing, best practice, resources, max worker threads, sqlperf, system

SQL Server Max Worker Threads - What is the best value to setup?
09 November 07 06:55 AM | SQL Master | 3 Comments   

We have been going through a load-performance exercise for an application that will have more than 5000 concurrent connections at one time. Going by books and expeirence by default the Max Worker Threads setting is 255, which means that up to 255 worker Read More...

Filed under: performance, sql server, server, best practice, setting, max, worker threads

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

Filed under: performance, sql server, microsoft, security, server, management, memory, windows, pae, awe, /3gb

How to check performance difference between 2 identical SQL Servers?
05 July 07 08:06 AM | SQL Master | 1 Comments   

Say you have two identical SQL Servers with similar databases in two different branches. Only the database sizes differ by about 20% and server machine are also identical. You will get a complaint that the performance of one is very very low compare to Read More...

Filed under: performance, sql server, server, query, stats

High CPU spikes affecting performance
26 April 07 01:59 PM | SQL Master | 2 Comments   

I have seen a common question across the forums & newsgroups that CPU is 100% when we are running a query on SQL Server. So it is important to understand whether CPU is affecting or is it a bad query that is affecting SQL Server performance in spite Read More...

Filed under: performance, sql server, security, server, stats, wait

Linked Servers performance - things to check
25 April 07 07:44 AM | SQL Master | 0 Comments   

I'm going to put the content that has been discussed in SSP forums about the Linked Server performance issues, there is much information available on the factors what you need to consider to avoid the performance loss. Here is the relevant forum post Read More...

Filed under: performance, sql server, microsoft, security, server, linked