Posts

Showing posts from August, 2010

Desempeño de SQL Server 2008 R2 y Max Worker Threads

Image
El parámetro max worker threads se utiliza para configurar la cantidad de worker threads disponibles para los procesos de SQL Server, esto ayuda a optimziar el desempaño cuando gran cantidad clientes están conectados al servidor. La opción max worker threads permite que SQL Server cree un pool de worker threads para atender a gran cantidad de peticiones, lo cual mejora el desempeño. La opción por omisión es 0 y permite que SQL Server configure automáticamente el número de worker threads al inicio del servicio. Algunas veces para mejorar el desempeño es mejor especificar un valor directamente, usted puede utilizar la siguiente tabla como referencia:Cantidad de CPUsservidor 32-bitservidor 64-bit<= 4 procesadores2565128 procesadores28857616 procesadores35270432 procesadoresFuente: http://technet.microsoft.com/en-us/library/ms187024.aspxCon base en el blog de Bob Duffy http://blogs.msdn.com/b/boduff/archive/2008/05/17/configuring-max-worker-threads-in-sql-2005.aspx se puede determinar …

SQL Server 2008 R2 Max Worker Threads and performance

Image
The parameter max worker threads is used to configure the number of worker threads available to Microsoft SQL Server processes, this helps optimize performance when large numbers of clients are connected to the server. The max worker threads option enables SQL Server to create a pool of worker threads to service a larger number of query request, which improves performance. The default value of this options is 0, and allows SQL Server to automatically configure the number of worker threads at startup. Sometimes to improve performance is better to specify a specific value, you can use the following table as reference:Number of CPUs32-bit computer64-bit computer<= 4 processors2565128 processors28857616 processors35270432 processorsSource: http://technet.microsoft.com/en-us/library/ms187024.aspxBased on Bob Duffy blog http://blogs.msdn.com/b/boduff/archive/2008/05/17/configuring-max-worker-threads-in-sql-2005.aspx you can determine the maximum number of threads SQL Server has actually …

Introduction to SQL Server 2008 R2

Image
In this presentation we review the new features in SQL Server 2008 R2. SQL Server 2008 R2 comes up with many enhancements in Security, Availability, Performance, Management, Storage, Programmability, BI( Business Intelligence ) and SSRS (Reporting Services) Introduction to microsoft sql server 2008 r2View more presentations from Eduardo Castro. Regards, Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://mswindowscr.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/default.aspxhttp://sqlserverpedia.blogspot.com/

Testing Idera SQL Server Diagnostics Manager

Image
I have being testing IDERA SQL Server Diagnostics Manager, in this blog I show you the basic steps to configure it to monitor a single SQL Server Instance. Idera SQL Server Diagnostic Managers offers an automated way to monitor your SQL Server Instances, after you install the software, you must follow this steps to configure it:1. Add the SQL Server Instance to be monitored2. You must configure what diagnostic information you want to collect3. If you want to monitor queries change the configuration as follows4. Click on start console5. On the console you can view the critical queries6. The query monitor can configure with thresholds 7.If you want the check the overall status of the server you can do it in the summary windowRegards,Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://mswindowscr.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.com