I currently have a single proc server in production and want to maintain a spare server that is dual-proc.
Is there a technical problem installing a single license SQL 2000 Standard on a dual-proc server? WIll it allow it or is it actually just a legal licensing requirement?
We are in process of moving to 64 bit HP servers with sql2005 standard edition. We were just wondering which is better option, to get a server with 2 dual core processor or to get a srver with just 4 processor? How does SQL2005 handle the hypertheading of dual processor?
Thanks,
Carlos
Hi,
I am running SQL7 SP2 on a Compaq Proliant 5500 (NT4 Server SP6a) with dual processor.
When trying to schedule any jobs with DTSRUN I get the following error:
DTSRun.exe - Application Error
The instruction at "0x77f64d7b" referenced memory at "0x00000010". The memory could not be read.
Has anyone seen this error before ??
Regards,
Tim
ok i have intel dual core i have a conflict only in playing a game black hawk down it gives me a run stop error. locks up and has to be restarted. microsoft gave me a fix but when i do the fix it causes me to get a system dump error on the game. i can update my web site do anything else let daughter play her games or do her school work and nothing happens. i was told i needed to set up the dual core so that my programs dont conflict i am a moron when it comes to computers is there a fix for this or i am i just going to have to go back to single core processor for now thanks
View 1 Replies View Relatedhi all,
I was under the impression that SQL Server 2005 can install on dual processor, quad core Intel machines.
Here's what we have: Intel Quad Core Xeon (E7340) @ 2.4Ghz. (8 way)
Has anyone encountered any issues w/ this setup -- particularly on this Intel CPU version?
thank you,
Cosmin
Does it mean "per hard drive" or "per CPU"(Pentium III, Pentium IV, etc.)? I'm a bit confused about it after reading a lot of books and article talking about processor license. Thanks in advance....
View 4 Replies View RelatedIf I install an instance of SQL Server on a box with 4 processors but specify in the licensing part of the installation procedure that it's a '2 processor license', does that really mean that SQL Server will only use 2 of the 4 processors? I ask because, having done this, if I check the SQL Server instance's properties, on the Processors tab, there are 4 processors ticked - giving the impression that 4 processors are being used by this SQL Server instance. Can anyone throw some light on this?
Another question... If I wish to reconfigure the same SQL Server instance from a 2 to a 4 processor 'per processor' license, how can this be done?
Clive
I recently completed developping my own e-Commerce model using SQL Server 2000 on Windows XP Pro .
However, now that I have it running smoothly, I would like to transfer the files to a dual Xeon 1.7 Ghz system with Windows Server 2003 with SQL Server installed for commercial use. I looked at the prices, and I was shocked to see a processor license for SQL server to be $5,000 to $20,000!
License Prices
I have a few questions comparing the free MSDE to actually purchasing a server license:
1. I undestand that MSDE limits the concurrent queries to 25 at a time... is that sufficient for a site that has say 500 visitors a day, who make 10-20 queries each? What about 1000 or 5000 visitors?
2. When the MSDE query manager detects too many queries, does it queue queries to resolve sequentially automatically? Or, does it just FAIL if there are too many queries? I'd hope that it would queue the query so that I don't have to go through my source and re-program each query to re-try in this case.
3. Is the 2GB database size limit of any concern on an ongoing basis? Seems to me that is more than enough as long as I erase some tables every few years.
If anyone has had experience with either/or system, I appreciate your advice.
Thanks,
Brent
We have an active database that sits on SQL Server 2000 that currently has per seat license...but now want to switch to per processor.
If I go to ControlSQL Server 2000 License Set up...it doe not give me the option to choose per processor.
Do I need to un-install/re-install SQL Server 2000 and choose the per processor choice and then re-attach our database ?
It seems like a lot of work..please advise.
Thank you
I need to upgrade a solution from SQL Express Advanced to Workgroup Edition because of the 4GB size limit. I'm planning on deploying the solution in an secure web enviroment were only authenticated users will be able to access the database. The actual username's and passwords would be stored in an Express database. Therefore since only named users would be accessing the database server web app, can I use the CAL license model??
View 1 Replies View RelatedI have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals.
Thanks,
Skip Berry
We are trying to setup a system to system failover cluster using twonodes (x346) which each have a single hba running to seperatecontrollers on the DS400.For full redundnancy, IBM recommends dual path from each node but wedont need that. The current setup has two completly seperate paths. hbaon node 1 to controller A on DS400 and hba on node 2 to controller B.If i take a controller offline, failover works fine to jumo to othercontroller and throw all resources to it's node but if i shutdown anode- the cluster loses all attached storage and DS400 is unaware toswitch ownership to other controller.Is there a way to us mscs without dual path from each node?anotherwords... if either node or controller fails on a single path, wewant the other path to become active.our main goal is to use sql server 2005 clustering on the cluster.everything checks out perfect if i only use one controller on the DS400for both nodes but this brings us back to another single point offailure.I saw that Qlogic has MPIO drivers on thir website for the DS400 but itseems as though they are for 32bit systems and the install errors outwith:C:Driversmpio1.0.8.4 (w32)>install.exe -iPre-Installing the Multi-Path Adapter Filter...SuccessInstalling the Multi-Path Bus Driver...Failure. Error code (0xe0000235)configuration:2 X IBM x346 w/ single QLogic 2340 HBAs running win2k3 64bit EnterpriseDS400 w/ dual controllers
View 5 Replies View RelatedHas anyone seen a problem where a SQL Server Application works on a server with a single Processor, However when placed on a box with multi-processors it fails. You do not receive any errors but the data set that is returned is not correct. When reviewing this problem on a test machine that only is a single processor we can not duplicate it. The Production Box is Multi Processor 2 pentium pro 200's with SQL Server 7.0 and no Service Packs. My Question is has any one ever seen this problem, and would installing the SP correct it, I plan on installing the SP's but I wonder if this could be the cause of the problem.
View 2 Replies View Related
I am working to develop an application using dotnet framework 2.0 that requires loading tab delimited text file (generated on each user action) in to table of SQL Express database. I am thinking to use SSIS library (Managed DTS) to call my SSIS package from within my application to load this data on each user transaction. This should be noted that I am not hosting my packages in to SQL Express.
Microsoft allows redistribution of SQL Express for free. Do I need any SQL Server or any other type of license for using SSIS library from my application?
-Faisal
I am planning to build a server to be used as a SQL Server and web server.Right now I can only use a single box for both.I have read some threads were dual processors are having problems with someparallel queries and the suggestions of having sql server use a single CPU.My budget is limited so I am debating whether to get 2.6G dual xeon 533FSBor dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu.If I get a dual cpu motherboard, is it a good idea to have 1 cpu used forsql server and the other for everything else?John Dalberg
View 5 Replies View RelatedI have a VERY Legitmate use to install sql 4 workgroups on a pc without licensing it. I am making a disk image for MANY pcs to be imaged and load licensing after the imaging is completed.
I have been able to do this with Windows XP Professional, MS Office 2003 and a couple non-Ms programs. The information for MS software even came from their KB, so I know what I am doing is legit. I just can't find any information on doing this for my sql app.
Any suggestions??
Respectfully,
Frustrated
"Frustrated"
I am running a query on a SQL Server 2005 database and encounter the following error message
"Internal Query Processor Error: The query processor encountered an unexpected error during execution."
There is a join between a table on the 2005 database and another on a 2000 database. I have run DBCC CHECKTABLE and found no errors on the two tables.
Anybody with ideas?
Thanks
Hi Friends,
I have a question. At my home computer i downloaded and installed VWD. As usual it also installed Sqlexpress as part of the installation(i checked the option). Later on i downloaded Management studio separately so i am fine with my home computer as every thing is free.
But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not understing where do i get the Management studio? Is it some thing i could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
Please advise. Thanks -L
SQL Server 2005 9.0.3161 on Win 2k3 R2
I receive the following error:
"Error: 8624, Severity: 16, State: 1 Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services."
I have traced this to an insert statement that executes as part of a stored procedure.
INSERT INTO ledger (journal__id, account__id,account_recv_info__id,amount)
VALUES (@journal_id, @acct_id, @acct_recv_id, @amount)
There is also an auto-increment column called id. There are FK contraints on all of the columns ending in "__id". I have found that if I remove the contraint on account__id the procedure will execute without error. None of the other constraints seem to make a difference. Of course I don't want to remove this key because it is important to the database integrity and should not be causing problems, but apparently it confuses the optimizer.
Also, the strange thing is that I can get the procedure to execute without error when I run it directly through management studio, but I receive the error when executing from .NET code or anything using ODBC (Access).
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
View 5 Replies View RelatedIn oracle you can run queries against some built in virtual table called dual. Like below:
SELECT SEQ.NEXTVAL FROM DUAL
does sql server have anything similar?
Greetings,
I'm wondering if it is possible to have two independent y-axes on a single chart?
I am wanting to plot data using a hybrid bar/line chart and have the values for the vertical bars show on the left y-axis and the values for the points on the line show on the right y-axis.
I've seen this sort of thing done on other platforms before, but don't know if it is possible with SQL Reporting. We are using SQL RS 2000 by the way.
Thanks
--
Anthony
I am searching for the MS SQL equivilent for the Oracle Dual command.
select 'hello' from dual;
Jeff
jchie@vafb.com
I've heard somewhere that SQL Server supports dual languages ? Can anyone confirm this ? How do you set it up please ?
Essentially we need to run our database in Japanese. It currently runs in english.
thanks
Paul
We have a 200MHz Pentium Pro based machine, with 128MB RAM running SQL Server 6.5. Because of performance issues, we are contemplating an upgrade to a dual 200MHz Pentium Pro processor with 256MB RAM. However, the vendor we are dealing with has suggested an upgrade to a single Pentiun II/333MHz first, and if this still causes problems, then to a dual P II/333MHz.
Does anyone have any suggestions from similar upgrades that they may have undergone?
We have 72MB allocated to SQL Server.
any tutorial on how to setup SQL Server in a dual redundant environment ?
thanks
I have created a C# Windows Forms application that can be run connected directly to SQL Server 2005 (publisher) for in-office users and to a SQL Express (subscriber) on a tablet PC for remote users. The server is set through configuration and the remote users sync using replication and it all works.
The issue I'm having is that I've found it necessary to install SQL Server management objects (SQLServer2005_XMO) on the clients who sit at desktops and never use replication or SMO. I believe this is because SMO has to be installed in the GAC and I can't just distribute the required dlls with my app.
Is there any way I can deploy this app to always connected users without installing SMO on their machines?
Thanks, Jamie Ide
Hi I am trying to populate a table with 2 FKs as its PK (SiteID and ProductDescID). First 1) I add in all the products whose Manfacturer and Category are supposed to appear on the site and then 2) I add in all the extra products that are needed regardless of their manufacturer or category. The problem I am having is if the product has already been added to the ProductCatTable due to its Manufacturer or Cateogry but is also in the SatForceProduct table. The can’t insert duplicate PK error is thrown. I don’t know how to do this IF NOT EXISTS statement (or what ever else may be needed) so that I can check whether a line from the Forced table needs to be added. I am not passing in any parameters and I am expecting more than 1 line to be inserted in each of the statements. Please help -- 1) Populate INSERT INTO dbo.ProductCatTable (SiteID, ProductDescID) SELECT dbo.SatSite.SiteID, dbo.ProductDesc.ProductDescID FROM dbo.SatManu INNER JOIN dbo.ProductDesc ON dbo.SatManu.Manu = dbo.ProductDesc.Manu INNER JOIN dbo.SatCats ON dbo.ProductDesc.Cat = dbo.SatCats.Cat INNER JOIN dbo.SatSite ON dbo.SatManu.SatID = dbo.SatSite.SiteID AND dbo.SatCats.SatID = dbo.SatSite.SiteID 2) Add Force Ins IF NOT EXISTS(SELECT SiteID, ProductDescID FROM ProductCatTable WHERE ????????) BEGIN INSERT INTO dbo. ProductCatTable (SiteID, ProductDescID) SELECT SiteID, ProductDescID FROM dbo.SatForceProduct END Thanks in advance J
This question may be a little complicated.
I am building a DTS Package that is moving data from our webstore (written in house) to a Warehouse Management System(WMS - Turnkey) and I've encountered a problem. both pieces of software have an orders table and an Ordered_Items table, related by the order_ID (makes sense so far). Here is the problem. The primary key on the webstore's Ordered_Items table is a single column (basically an Identity variable), while the primary key on the WMS's Ordered_Items table is a dual column primary key, between the Order_ID and the Order_LineID, so the data should be stored like:
OrderID Order_LineID
1 1
2 1
2 2
2 3
3 1
3 2
4 1
Get the Idea? So I have to create this new Order_LineID column. How can I accomplish this with a SQL statement?
Thanks!!!!!
Hi,
I am running MSSQL 2005 Standard edition on a two processor Intel Xeon 3GHz (dual-core) with 8GB RAM.
I notice in "Windows task manager CPU performance" while running a long SQL statement (takes 1.5 hours), only 1 logical (out of 4) is utilised at >70%. The remaining 3 logical processors hover around 10%
Using Performance monitor, the average read queue, write queue, and pages/sec also hovers around 25%, indicating no heavy physical disk/memory loading.
How can I set to utilise more physical/logical processor to improve the MSSQL performance ?
Thanks.
Hi,I've been creating a db application using MS Access and MSDE. Only twoof us are using the application, and the server and the app both rungreat on my laptop (1.6 GHz Pentium M, 2GB RAM, W2KPro). Only problemis when I take my laptop home, my coworker loses access to the server.We recently purchased a dedicated server to run the db on at theoffice. It's a 2.8 GHz Dual Xeon, 2GB RAM, running XPPro. We alsobought SQL Server, but I installed the Personal Edition becuase we arenot using a server OS. It's my understanding that XP can utilize bothprocessors, and the Personal Edition can use both processors as well.(On a side note, why is Enterprise Manager showing that I have 4processors - why?) In addition, I understand PE has a work-loadgovernor that cripples performance when more than 5 TSQL commands arebeing run simultaneously.I backed up the db on my laptop and restored it on our new server. Butwhen I run the exact same queries with the exact same number of rows,my queries on the new server are take 3x longer(!?). Can someoneplease offer a few suggestions for why this is happening? What can Ido to improve performance on the server machine?Please let me know if I need to supply more information.Thanks,Alex
View 15 Replies View RelatedHi,Is there a reason why we have to pay more for licensing for a differentkind of processor?Why are we not charged for the Hyperthreading on some processors also.If Oracle is really conserned about the low end business market (smalland medium), then they should drop their attitude on Dual Coreprocessors.If they start charging as if it was a normal processor, and ask thenormal price, then they would get more of this market coming in.As long as Oracle keeps on having the attitude of charging more,because Intel or some other cpu vendor decided to mprove theirprocessors because of overheating problems, I will have the attitudethat I will keep on reoccomending alternatives for Orcle like Mysql /Postgre sql / Sybase, etc to the small/medium sector.Microsoft's pricing model on double core processors suddenly soundallot better.Oracle are shooting themselves in the foot! Or am I the only personfeeling this way?Shaun O'Reilly
View 2 Replies View RelatedAssume I built a stored proc (dbo.testproc) that will return the OUTPUT parameter @RandomInteger.
I could pass a specific value for the parameter...
EXEC dbo.testproc 7
Or I could return a value from the proc...
DECLARE @ReturnInteger
EXEC dbo.testproc @RandomInteger = @ReturnInteger OUTPUT
SELECT @ReturnInteger
But I want to do both which, if this actually worked, might look like this...
DECLARE @RandomInteger
SET @RandomInteger = 7
EXEC dbo.testproc @RandomInteger = @ReturnInteger OUTPUT
SELECT @ReturnInteger
I want to pass a specific value and return the result from the proc. Do I need to use two parameters for this?