.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Max Worker Threads CPUs vs Cores

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
I am reading the documentation published here http://technet.microsoft.com/en-us/library/ms187024.aspx I would be interested in knowing how the results published here get impacted with I say 16 cores rather than 16 CPU.

View Complete Post

More Related Resource Links

Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?

I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by only one user. It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes... Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage. Can anyone explain the relationship between SQL Server perfomance and hardware ?

ASP.NET Architecture - ASP.NET Worker Process - HTTP Pipleline - Http Modules and Handlers

"ASP.NET is a powerful platform for building Web applications, that provides a tremendous amount of flexibility and power for building just about any kind of Web application. Most people are familiar only with the high level frameworks like WebForms and WebServices which sit at the very top level of the ASP.NET hierarchy. In this article I'll describe the lower level aspects of ASP.NET and explain how requests move from Web Server to the ASP.NET runtime and then through the ASP.NET Http Pipeline to process requests.

This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

Multiple Paramatized Threads



I have a  method that calls two subsequent methods that contain multiple parameters. I would like to run these methods simultaneously and then preform an action based on the return of both methods, so The parent thread cannot continue until BOTH threads have completed. I have tried going trough MSDN examples and haven't got anything to work (the issue is that the parent thread (aka the main method) continues on once one of the thread completes). I have tried cheking the state of threads and waiting the threads, but have not gotten anywhere. Any help would be great. Thanks.

Pooled Threads: Improve Scalability With New Thread Pool APIs


The new threadpool APIs in Windows Vista and in the upcoming Windows Server 2008 provide advances that even native Windows developers can benefit from.

Robert Saccone

MSDN Magazine October 2007

WPF Threads: Build More Responsive Apps With The Dispatcher


Understanding the Windows Presentation Foundation threading model helps when creating user interfaces that are both compelling and responsive.

Shawn Wildermuth

MSDN Magazine October 2007

Wicked Code: Running ASMX Web Services on STA Threads


Jeff Prosise describes performance problems in an ASMX Web service that relied on legacy COM and Visual Basic 6.0 to perform key processing tasks and the approach he took to find a fix.

Jeff Prosise

MSDN Magazine October 2006

ASP.NET Pipeline: Use Threads and Build Asynchronous Handlers in Your Server-Side Web Code


Fortunately for developers, threading in ASP.NET is a lot easier than it was in ASP. In this article, the author takes a look at threading in the ASP.NET HTTP pipeline, and explains how threads are managed efficiently without the involvement of the developer. The article considers how the common language runtime threadpool is used by ASP.NET to service requests, looks at the pooling mechanisms used for handlers, modules, and applications, and covers both IIS 5.0 and IIS 6.0 and how they differ in their approach to request processing and thread allocation. Finally, how and when to use asynchronous handlers is discussed for developers who still need to use threads in their own applications.

Fritz Onion

MSDN Magazine June 2003

Windows Forms: Give Your .NET-based Application a Fast and Responsive UI with Multiple Threads


If your application performs any non-UI processing on the thread that controls the user interface, it may make the app seem slow and sluggish, frustrating users. But writing multithreaded apps for Windows has long been restricted to C++ developers. Now with the .NET Framework, you can take advantage of multiple threads in C# to control the flow of instructions in your programs and isolate the UI thread for a fast and snappy user interface. This article shows you how. Also, it discusses the pitfalls of multiple threads and presents a framework for safe concurrent thread execution.

Ian Griffiths

MSDN Magazine February 2003

Educational question: How server objects are accessed from multiple client threads?

I will appreciate it if someone can help me to undestand how the following scenario works:   There is remoting server that is registered as WellKnownObjectMode.Singleton. Server implementation: It instantiates a class TestServer that implements interface IFoo interface IFoo { IHelper GetHelper() }   interface IHelper { void StoreString(); }   Implementation of TestServer: internal sealed class TestServer: System.MarshalByRefObject, IFoo { private IHelper> helper = new Helper(); public IHelper GetHelper(string helper){return helper;} }   Implementation of Helper: internal sealed class Helper : System.MarshalByRefObject, IHelper { public void StoreString (string val) {}; }   Implementation of a client (simplified; shown to illustrate the question only): static class Program { public static IFoo TestService; public static IHelper Helper; public TestThreads testmultiplecalls; [STAThread] static void Main() { TestService = (IFoo)Activator.GetObject(typeof(IFoo),"ipc://Channel"); Helper = TestService.GetHelper(); testmultiplecalls.Start(); } }   internal class TestThreads { public Start() { for (int i = 0; i < 20; i++) ThreadPool.QueueUserWorkItem((new TestCall(i.ToString())).DoWork); } }     internal class TestCall { private string m_str; public TestCall (string str) {m_str = str;} public void DoWork() { Program.Helper.StoreString(m_str); } }     Que

Maximum Number of Processor Cores in CLR

Is the maximum number of processors (cores) supported by different versions of the CLR documented somewhere?  I'm working on an application hang problem and I can see in dumps that a thread is waiting in mscorwks!ThreadpoolMgr::RecycleMemory for a flag whose address was calculated by using the processor number as an index.  I can't see the index in the dump, but the machine has 48 processors and it looks as though the array containing the flags can accomodate only 32 processors, so the thread might be waiting on something beyond the array. Another clue is that there are only 32 GC threads, so I'm suspicious that this CLR will only scale to 32 cores. The CLR in use is the 32-bit version of 2.0 running on 64-bit Windows 2008 SP2.  I'd like to see whether there is a restriction on the number of processors in that version and, if so, whether there is another version that would support more.

Exception Propagation across threads.

How can I propagate exception which is being raised in child thread to its parent thread? Please note that child threads could be running asynchronously.

Information Worker 2010 VM - Is boot from VHD possible

I've downloaded the Information Worker 2010 VM from: http://www.microsoft.com/downloads/details.aspx?FamilyID=751fa0d1-356c-4002-9c60-d539896c66ce&displaylang=en I don't have a Windows 2008 R2 Hyper-V Host to test this out on (only got Windows 7 on my laptop at present), does anyone know if it's possible to use the VHD as a bootable VHD? I simply tried to add a bcdedit entry to point at the VHD but when I tried to boot it blue-screened and restarted my laptop. Does this require running the bcdboot command on the VHD? Cheers, Colin

Information Worker 2010 - Web applications do not show up

i have Information Worker 2010 VHD running on VMware-MacBookPro with 6Gb ram. I converted vhd to vmware and it runs fine but for watever reason am unable to bring up the various web applications in the VM. I can goto Central Admin but the web applications (each is configured with a host header) simply dont show up.  i googled for hrs and have tried DisableLoopback thread etc., checked dns entries but nothing helps. What am trying is definitely not to be done in a production env, which is running web app on local server. has anyone been able to bring up web apps successfully. 

Open dialogue box in background worker

Hi, I am getting an error trying to open a dialogue box in background worker. Please help.   Imports System Imports System.Drawing Imports System.Windows.Forms Imports System.IO Public Class Form1 Inherits Form Private folderBrowserDialog1 As FolderBrowserDialog Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click bgw.RunWorkerAsync() End Sub Private Sub BGW_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles bgw.DoWork Dim result As DialogResult = folderBrowserDialog1.ShowDialog() End Sub End Class

Handling Threads in WCF Service

Hi All, I have a WCF serivce which will be called by many clients at the same time. So i set concurrency mode as multiple. So its working fine. In my database i have set time limit for processing each request. So if a particular request is not executing with in that time limit i need to kill(abort) that thread and that request should be given to a new thread. Can any one give me an idea on this that how can i do this? Thanks Lijo.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend