SqlServer-QA.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 test the implications and usage in hiking such a value that will affect the whole server ...

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 threads are allowed to be created. Most of the times I never had any issues ...

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 to rely upon SYSMON counters. In this scenario capturing the Available Byes & ...

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 application too. So now the question is will there be any limit on ...

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 available to process this command. For the error text it looks like the system is unable to fine ...

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 the reason that memory has been a constraint on scaling-up server capacity. Once you consider ...

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 of business logic that programmers can write with these languages. But think about performance ...

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 the available documentation on Technet & MSDN it is pretty informative that ...

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 another, so how to find the issue to resolve? If you have a test platform it is better to ...

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 (SYSMON) is helpful here and the SQL Server 2005 Analysis Services performance monitor counters ...