Browse by Tags

All Tags » sql server » server   (RSS)
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...
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...
SP_HELP_REVLOGIN for SQL Server 2005
04 September 07 06:54 AM | SQL Master | 2 Comments   
SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure 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...
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...
Get SYSMON counters using a TSQL query aka DMVs.
31 May 07 08:26 AM | SQL Master | 1 Comments   
SYSMON aka PERFMON is a best tool to find out the system resources usage on a Windows server, similarly SQL Server 2005 has list of such useful DMVs to get you more information on many of the SQL Server-related objects, instances and counters by using Read More...
Unable to continue SSIS package after SP2
27 April 07 06:21 AM | SQL Master | 0 Comments   
From time to time we manage our SSIS packages by modifying the configuration file to allow the execution even though the service is stopped. 2 of the packages were working perfectly until we have applied the Service Pack 2 for SQL 2005 couple of weeks Read More...
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...
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...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication