Browse by Tags

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Published 15 November 7 9:41 AM | SSQA.net

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

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

SQL Server Max Worker Threads - What is the best value to setup?

Published 9 November 7 7:55 AM | SSQA.net

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

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

Paging and Available Memory for Operating sysem, what you need to know?

Published 6 September 7 7:29 AM | SSQA.net

Performance tuning exercise involves using SYSMON for the server based tasks, also I have seen users referring that MEMORY is at peak level by referring to Task Manager on the server. Not always depend upon the task manager, for optimum information better...

Filed under: sql server, performance, microsoft, server, sysmon, paging, vmm, processes, virtual memory

Number of databases limit for Database Mirroring within X64 environment?

Published 30 August 7 5:27 AM | SSQA.net

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server...

Filed under: sql server, performance, high availability, server, database mirroring, x64, geographic

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: sql server, performance, memory, server, process, cube, Analysis Services

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: sql server, performance, memory, server, windows, x64, system, hardware, 32 bit, 64 bit

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: sql server, performance, memory, server, clr, tsql, managed code

/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: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae

How to check performance difference between 2 identical SQL Servers?

Published 5 July 7 10:6 AM | SSQA.net

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

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

Monitor Analysis Services performance

Published 4 May 7 2:12 PM | SqlServer-QA.net (SSQA)

Within the Relational SQL Server engine monitoring the performance is easy with pre-equipped tools such as Profiler, Database tuning advisor and Performance Monitor (SYSMON). How about for BI - Analysis Services monitoring in this case. Again PERFMON...

Filed under: performance, analysis, server, bi