.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

How to dedicate CPUs to SQL Server only such that it won't be shared with OS

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi, On our SQL Server hardware, we have two quad core CPUs (8 CPUs from SQL server perspective) I understand that I can limit SQL Server to take only 1 core (4 CPUs) out of 8 CPUS, but my understanding is it might be shared with OS depends of the load of other applications running on the server. Is there any way to configure the server (OS+SQL Server) that dedicate 1 core (4 CPUs) to SQL server and allocate the rest of CPUs for OS and the rest of running applications including Integration Services? My understanding is dedicated CPUs to SQL Server doesn’t include SSIS. Is that right? Thank you, Max

View Complete Post

More Related Resource Links

Installing Microsoft.ACE.OLEDB.12.0 on a shared server--supported or not?

Here's the scenario: we have a Web application that needs to open an Excel 2007 file, read the sheet names and pass the sheet selected by a user to a SSIS package for processing on the DB server. During development, we discovered that the Microsoft Access Database engine (Microsoft.ACE.OLEDB.12.0) is required for our application to perform these tasks when running on a 64-bit server. Details: ASP.NET 4/VS 2010/SSIS on SQL 2008 R2; 32-bit environments have no issues; 64-bit requires installation of the provider. We followed this link to get the components: http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en We have installed the components and everything works great in our development and test environments. However, we must deploy to a 64-bit environment that is controlled by our customer's IT group, not by us. They are balking at installing the components because of the following statements that appear on the download page in the "Additional Information" section: "The Office System Drivers are only supported under certain scenarios, including: " Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files. To transfer data between supported file formats and a database repository such as SQL Server; in the

online shared hosting sql server problem

 hi all             how to solve the problem in online sql server. A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)thank u

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 ?

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

SQL Server Standard Edition and Servers with more than 4 CPUs:

Hi, We are planning configure a SQL Server 2008 R2 Standard Edition on a server with 8 CPUs - two quad core with hyper threading. The server also runs many SSIS packages and SSRS reports. We would like to assign the highest priority to SQL database engine. Considering the fact that SQL Standard does not leverage more than 4 CPUs, what would be the best way to dedicate most of CPU power to SQL Server database engine? I already found that I can’t dedicate SPUs to SQL Server through this post: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/3b797fc8-3bea-422d-b172-7d1a93195c69 I am a bit concern that manipulating the default settings for Affinity and SQL Server priority might cause harm. That is why I am asking for a good practice for specific circumstance explained here. Any help would be appreciated, Max

Where is the Office SharePoint Server Shared Services

We want to enable Excel Services on our sharepoint. I think I have to somehow enable Shared Services. I googled, but on all the pages they say: "On the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm's shared services."

But on our Central Administration site there is no Office Sharepoint Server Shared Services section.

On another page is says: On the SharePoint Central Administration Web Site, Click SharedService1 (in the quick launch part under 'Shared Services Adminsitration'). But this link is not on our Central Administration web site.

I'm logged in als the System Account of the sharepoint. (tfsservice account).

Am I missing something? Or do I have to install something to het Shared Services?

How to install SQL Server 2008 shared features in another directory?


The Shared feature directory is greyed out during installation.  I have uninstalled all SQL Server 2008 instances and shared features.

I thought this might be caused by SQL Server 2008 Browser and SQL Server 2008 Setup Support Files were still installed.  SQL Server 2008 Browser was used by SQL Server 2005 instances and was depending on SQL Server 2008 Setup Support Files.  I have uninstalled them but the Shared feature directory is still greyed out.  So, how to install SQL Server 2008 shared features in another directory without uninstalling SQL Server 2005 instances and shared features?  If it is not possible due to shared tools between SQL Server 2005 and SQL Server 2008, can it be done by only uninstalling SQL Server 2005 shared features? If yes, which SQL Server 2005 shared features must be uninstalled?


Shared SQL server


Hi, I'm setting up a shared SQL Server using SQL 2008. Each sql login only has access to one database and i need each account to have read and write access to their database and be able to manage their database through a remote SSMS connection.

I've trid to confirure this myself but without granting db_owner (which I really dont want to do ) , I'm not able to get the database to appear in SSMS.

[Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]


Hello All,

I am using MS SQL SERVER 2008. Im making an application which queries trillion of records. Im using PHP as scripting language. For those functions , which query database and 200 (approximately) rows of DB are returned, everything works fine. But if I query database and a large recordset should be returned, the following error is thrown:

Array ( [0] => Array ( [0] => 08S01 [SQLSTATE] => 08S01 [1] => 258

=> 258 [2] => [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]. [message] => [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]. ) [1] => Array ( [0] => 08S01 [SQLSTATE] => 08S01 [1] => 258
=> 258 [2] => [Microsoft][SQL Server Native Client 10.0]Communication link failure [message] => [Microsoft][SQL Server Native Client 10.0]Communication link failure ) [2] => Array ( [0] => 08S01 [SQLSTATE] => 08S01 [1] => -2147467259
=> -2147467259 [2] => [Microsoft][SQL Server Native Client 10.0]Communication link failure [message] => [Microsoft][SQL Server Native Client 10.0]Communication link failure ) )

If I see the error log it shows:

2010-10-17 12:32:38.88 Logon       Error: 18456, Severity: 14, State: 8.

2010-10-17 12

SQL Server 2008 NUMA CPUs problem


Hello there,

I have three IBM x3950 M2.

Each IBM have four physical CPUs and each CPUs have 6 cores with 48GB of memory.
They are merged together so I have a host with 12 CPUs (72 Logical) and 144GB of memory.

I'm running Windows Server 2008 R2 Datacenter without any problem, my three NUMA nodes are detected.

The problem is with SQL Server 2008 Enterprise. It detect only 48 CPUs instead of the 72. The memory is detected correclty SQL report the 144GB.

In the ERRORLOG file I have:

Detected 48 CPUs. This is an informational message....
Node configuration: node 0: CPU mask: 0x0000ffffff000000 Active CPU mask: 0x0000ffffff000000.
Node configuration: node 1: CPU mask: 0x0000000000ffffff Active CPU mask: 0x0000000000ffffff.

From the view sys.dm_os_nodes I only have two nodes reported has online each report 24 online scheduler_count. I have a third node but it's for the DAC.

Since Windows is able to detect all CPUs I don't understand why SQL Server is not able to detect them.
So my question is how can I setup SQL Server to detect all my CPUs?

Thank you.


linq not working on shared server with Medium Trust security


On my PC everything is all rigth but on the webserver I get an error: 'OrderBy' is not a member of 'System.Array', maybe due to the trust level.
Is there I way to bypass this or I have to resign myself to it?

Single shared "SQL Server Administrator" account or multiple accounts?


We have an environment where one of several admins might be asked to perform administrative tasks on a SQL Server 2008 running WS 2008 R2.

We are running mixed authentication and want admins to log in and administer SQL server and the database using their own admin accounts.

What I would like to do during installation, under "data base engine account provisioning" is add a domain security group to the list of SQL administrators and make sure that the admins who are allowed to administer SQL server and the database are in that group.

Is there a downside to doing that? for example the admin who runs the initial script to create the database might end up the owner of the DB... Will that be a problem, or is there some other approach we should take on this?

What I'm trying to avoid is having admins share a Windows account for DB administration. We mostly use remote desktop for admin tasks and that gets messy with a shared account.


Distributed shared memory and sql server?



Not sure this is the right forum but, I'll give it a shot anyway;

Recently I've been into discusions about distributed shared memory to hold a synchronised copy of database in memory in order to remove load from dB.

There're a lot of opensource / solution about this mainly for the linux world as I can see it. (http://en.wikipedia.org/wiki/Distributed_shared_memory)

Just curious to know what the microsoft approch to this architecture is.



call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.

jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
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