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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SQL Server 2008 R2 Standard edition running from one Core

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :Sql Server
 

Hi, I have a client who we just upgraded to Win 2008 R2 Standard Edition and SQL 2008 R2 Standard Edition

They are complaining about System performance. 

Looks like SQl runs only on 1 core, maybe sometime 2 which is maxed out.

"Automatically set Processors affinity mask for all processors" is checked and also

"Automatically set I/O affinity mask for all processors" is checked...

The server was maxed out with memory a few days ago but looks to me that that is something taht SQL 2k8 R2 does. The server has got 16GB ram

Pretty urgent. Got 3 hours to solve it.


Thanks

 




View Complete Post


More Related Resource Links

Failures in running Repair for 2008 SQL Server standard edition

  

Dear users,

2008 SQL Server Standard edition.

 

While running Repair I got below failures,

1. Upgrade failed due to the following error. The error code is :-214747259.Message:Unspecified error

2. The process cannot access the file 'C:\Windows\system32\perf-SQLSERVERAGENT-sqlagtctr10.0.1600.22.dll' because it is being used by another process.

3. The service did not start due to a logon failure.

I wonder what causes the failures and what I should do to fix them.

 

Could you tell me what to do?

Thank you,

 


In windows server 2008 standard edition feature Failover clustering is not looking

  
In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

What are the memory limits of SQL Server 2008 Workgroup edition (32 bit/non-R2) running on Windows S

  

We have a situation where one of our customers is running Windows 2003 Enterprise Edition 32bit with 8 GBs of physical RAM. Upgrading to Windows Server 2008 64bit is not an immediate option (although I wish it were). All the documentation about SQL Server 2008 Workgroup edition indicates that the new version will address 4 GBs of memory however it does not distinguish between 32bit vs 64bit.

Previously we have run SQL Workgroup 2005 under Windows 2003 and have applied the /3gb switch in boot.ini to get SQL to recognize the maximum amount of memory possible. Now that we are using SQL 2008 with the /pae switch, do we need to still specify the /3gb switch or can SQL 2008 32bit actually see more than the 3GBs and address 4? I haven't been able to find any information on this configuration.

 

 

 


Upgrade SQL Server 2008 Standard Edition to 2008 R2

  
I'm trying to find the right down load to use to upgrade SQL Server 2008 Standard Edition to Standard Edition R2.  This is the first upgrade I've done for SQL Server and I can't find any download for R2 that is specifically for Standard Edition.  Can anyone point me in the right direction please?

MS SQL 2008 SBS install fails on Server 2008 R2 Standard edition

  

According to edition requirement (http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx), I thought I met the requirements but this link tells me not only I need both the standard edition AND in a domain??  I have Windows 2008 Standard R2 edition.

 

This is a standalone server and there's no domain.  I can promote it to be a domain controller but don't want that.  Is it the "R2" part that its failing.  I can downgrade to the non-R2 with SP2.  (Windows Server 2008 with sp2).


SQLPUBWIZ for Microsoft SQL Server Standard Edition (64-bit) 2008

  

Where can I find a download for the SQLPUBWIZ which will work on the following version:

Microsoft SQL Server Management Studio      10.0.2531.0
Microsoft Analysis Services Client Tools      10.0.1600.22
Microsoft Data Access Components (MDAC)      6.1.7600.16385
Microsoft MSXML      3.0 5.0 6.0
Microsoft Internet Explorer      8.0.7600.16385
Microsoft .NET Framework      2.0.50727.4952
Operating System      6.1.7600

All the version I found on the net sofar won't work on 2008 ...

Regards

Herman 


Microsoft SQL Server 2008 Standard Edition for Small Business supports Windows 7 Pro ?

  

Microsoft SQL Server 2008 Standard Edition for Small Business supports Windows 7 Pro ?

I have try to install its failed at Rule check is their any work around?

many thanks

Regards

NMJ


SQL Server 2008 R2 Standard edition License update (Developer license to Production License)

  

We have an MSDN copy of the SQL server 2008 R2 standard edition which we have installed in production environment. We have subsequently bought a licensed copy of MS SQL server 2008 r2 Standard edition. Using the feature Maintenance and Edition Upgrade in SQL setup, we have updated the licensed product key information of the SQL server 2008 R2 from licensed setup file in production environment. We wanted to know how to view the licensed product key information from the server. Also we wanted to check if we have completed the process and we are legally using the software

Query: select serverproperty('LicenseType'),serverproperty('NumLicenses') Is always returning “Disabled” and “NULL” before and after using Edition upgrade with valid license details.

 


cannot install Microsoft SQL Server 2008 Standard Edition for Small Business

  
im trying to install this on MS windows Server 2008 R2 STD ED.  is says on the installation " Operating system supported for this edition " ( failed ). is it not compatible with my O.S. thank you.

MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

  
Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

  
Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

sql server 2008 R2 Developer Edition

  
I am having trouble finding a place to actually purchase the developer edition of Sql Server 2008 R2. I went to CDW and they provide the ability to purchase a developer license but don't provide the actual software. Where can I actually purchase the developer edition without subscribing to MSDN? Thanks Royal

SQL Server 2008 R2 Developer Edition

  
I've been looking to get SQL Server 2008 R2 Developer Edition since I discovered that there was going to be one.  My question is, where do i get it?  I can't find any place that references a place to buy it, or upgrade to it.  Any ideas?

SP 2010 and Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition

  
Hello,Will it be possible to install SharePoint 2010 on Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition?Thanks

Please Advice SQL 2008 Standard Edition

  
·         I have a issue with subscriptions since we have SQL 2008 Standard edition and i found out that Data Driven Subscription are disabled. We have about 100 reports subscribed by our internal & external customers. I have a DB "Prices" In that we have 4 Tables, Analysts,Users,SalesReps & Sub Sales rep the subscriptions are by anyone and everyone from these 4 tables.... we have a Project thats in Build in sql server 2008, which is a repository for all our 100 reports....basically what we are trying to do is based on Relationship, security level and user hierarchy they can access the reports... Any ideas will help ???????????FM
Categories: 
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