Dual Core Processor Conflict Graphics Card

May 7, 2007

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


ADVERTISEMENT

Dual Core Processor

Aug 3, 2007

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

View 1 Replies View Related

Standard Edition 2005 Not Installing On Dual Processor Quad Core (8 Way)

Feb 27, 2008

hi 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

View 3 Replies View Related

How Can I Use Dual Core CPU For Performance Improvement

Jul 17, 2007

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.

View 2 Replies View Related

Oracle Licensing For Dual Core Processors

Nov 23, 2005

Hi,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 Related

DTSRUN Error On SQL7 With Dual Processor

Jul 31, 2001

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

View 1 Replies View Related

Single License Installed On Dual Processor

Oct 28, 2004

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?

View 3 Replies View Related

Can SQL 2005 Make Full Use Of A Quad Core Processor

May 22, 2008

I am new to this so I hope I'm doing it right.

We are in the process of replacing a computer that currently has SQL 2005 Management Studio Express installed. We are looking at a Intel Core 2 Quad processor (Q6700) and want to know if SQL will be able to make full use of a quad core. Thanks

View 10 Replies View Related

Dual Xeon Or Dual P4 For SQL Server?

Jul 20, 2005

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 Related

Online Graphics

Dec 15, 2007

Hello all! Im new to SQL2005. If it is possible to see realtime graphs from tables? For example current sales result?

Thanx

View 1 Replies View Related

Storing And Restoring Graphics

Apr 20, 2007



hi,

i want to draw a bitmap programaticaly and store it to a db.when i try to display it from the db the drawings appear in a black back ground . how can i solve this problem.

i restore the bitmap by using a dataset and data bind contrls from

visual studio designer and codes to draw and store the bitmap is here :



private void button1_Click(object sender, EventArgs e)

{

pictureBox1.Paint+=new PaintEventHandler(pictureBox1_Paint);

pictureBox1.Refresh();

}

private void pictureBox1_Paint(object sender, PaintEventArgs e)

{

PaintImage(e.Graphics);

}

private void PaintImage(Graphics gr)

{

int p1 = Convert.ToInt32(textBox1.Text);

int p2 = Convert.ToInt32(textBox2.Text);

int p3 = Convert.ToInt32(textBox3.Text);



Pen myPen = new Pen(Color.Blue);

gr.DrawCurve(myPen, new Point[] { new Point(50, p1), new Point(100, p2), new Point(150, p3) });

}

private void button2_Click(object sender, EventArgs e)

{

Bitmap bmp = new Bitmap(pictureBox1.Width,pictureBox1.Height );

Graphics gr = Graphics.FromImage(bmp);

PaintImage(gr );



MemoryStream stream = new MemoryStream();

bmp.Save (stream, System.Drawing.Imaging.ImageFormat.Bmp );

byte[] bytes = stream.ToArray();

SqlConnection sqc = new SqlConnection("server=farhad;database=graphics_test;integrated security=sspi");

SqlCommand cmd = new SqlCommand("insert graph values(@p1,@p2,@p3,@graph)");

cmd.Connection = sqc;

cmd.Parameters.Add("@p1", SqlDbType.NVarChar);

cmd.Parameters.Add("@p2", SqlDbType.NVarChar);

cmd.Parameters.Add("@p3", SqlDbType.NVarChar);

cmd.Parameters.Add("@graph", SqlDbType.Image);

cmd.Parameters[0].Value = textBox1.Text;

cmd.Parameters[1].Value = textBox2.Text;

cmd.Parameters[2].Value = textBox3.Text;

cmd.Parameters[3].Value = bytes;

sqc.Open();

SqlDataReader reader = cmd.ExecuteReader();

reader.Read();

reader.Close();

sqc.Close();





}

View 1 Replies View Related

Internal Query Processor Error: The Query Processor Encountered An Unexpected Error During Execution.

Nov 26, 2007



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

View 3 Replies View Related

Error: 8624 Internal Query Processor Error: The Query Processor Could Not Produce A Query Plan.

May 24, 2007

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).

View 5 Replies View Related

SQL Server && Core Duo CPU

Feb 23, 2007

Problem: We have a set of sql queries and one core duo processor. We want one subset of queries would be executed on first core of our CPU and the rest of queries would be executed on the second core of CPU. We are using MS SQL Server 2005 – Workgroup edition.

Is there any way how to do this with one instance of SQL Server or with two instances at least (is there any way how to force an instance A to use CPU1 (first core of core duo CPU) and instance B to use CPU2 (second core of core duo CPU)) ?

Thank you for your ideas!
Jan

View 1 Replies View Related

Quad Core

Nov 1, 2007

The number of data files within a single filegroup should equal to the number of CPU cores. So for a quad core CPU there should be 4 data files. Is there anything that one need to take care besides creating the data files for a filegroup. I belieev SQL takes care of itself how to update data files .

View 5 Replies View Related

Quad Core

Feb 20, 2008

Does SQL 2005 Enterprise utilize Xeon Quad Cores? or should i go with Dual Cores?

if it DOESNT, any idea if they plan on releasing a service back to allow it to?

View 9 Replies View Related

How To Dedicate A CPU/Core To MS SQL

Dec 10, 2007

We just purchased a Quad Core xeon server. It it my understanding that express can only utilize a single cpu/core. Is there a way I can setup windows or ms sql server to dedicate one particular core soley for ms sql?

View 3 Replies View Related

Does Sql Server Have Something Like Dual

Dec 6, 2004

In 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?

View 2 Replies View Related

Dual Y-Axes

Dec 27, 2006

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

View 6 Replies View Related

CONFIGURATION IN THE CORE 2 DUO PROCESOR

Sep 5, 2007

Hello,

I need change a SQL Server 2005 configuration, this service is placed in a server with 2 Physical processors dualcore and 4 processing nucleus.

I need that it´s use only one of the Physical Processors....How i do that?

TKS

View 1 Replies View Related

Speaking Of The Core 2 Duo Chip

Mar 7, 2007

Is it true that SQL Server treats it as 2 processors and Microsoft only charges 1 license?

That sounds VERY un-Microsoftish......but I'd better shut up....MS is probably in the process of figuing out how to nik me more for my license.)

View 1 Replies View Related

MS SQL Equivilent For Oracle DUAL

May 25, 2001

I am searching for the MS SQL equivilent for the Oracle Dual command.
select 'hello' from dual;

Jeff
jchie@vafb.com

View 2 Replies View Related

Dual Language Support

Sep 13, 2000

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

View 1 Replies View Related

Dual Processors & Performance

Mar 17, 1999

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.

View 3 Replies View Related

Dual Redundant Environment

Mar 15, 2007

any tutorial on how to setup SQL Server in a dual redundant environment ?

thanks

View 3 Replies View Related

Deploying Dual Use Applications With SMO

Feb 20, 2008

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

View 1 Replies View Related

MS SQL 2005: Performance – Normal CPU Vs CPU DUO/4 CORE

Mar 1, 2007

Hello,

Is performance of web application (ASP.NET + SQL Server 2005 Wrg edition + Win Server 2003 Web edition) running on server with one core duo/4 CPU generally comparable to the performance of the same application running on the same server with 2/4 physical CPU’s?

Thank you for your ideas!
Jan

View 1 Replies View Related

SQL 2012 :: Getting CPU Core Count For Licensing

Aug 13, 2015

I configured an SSIS package to collect information about servers in our environment and as a part of it the package collects the Physical and Logical CPU's. Since we are on per-core licensing for SQL Servers, i would need to get the exact core count. I can simply do Logical cpu / Physical CPU to get the Core count assuming that hyperthreading is turned on. What if the hyperthreading is not on, then i would end up getting the wrong Core count.

I query the registry to get this info. I would like to get your inputs for getting the exact core count on Windows servers with Intel and AMD processors.

View 3 Replies View Related

Insert Not Exists Dual PK Problem

Mar 17, 2008

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
 

View 2 Replies View Related

Creating A Table With A Dual Primary Key

Jul 12, 2004

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!!!!!

View 5 Replies View Related

Core Data Type Question (bigint)

May 10, 2005

We are trying to work with our developers to upgrade to SQL 2000 from SQL 7 for a critical applicaion and all looks good in testing for the most part.  The concern that our developers have is that in order for the application to work on the test SQL 2000 server they had to delete a core data type (bigint) for the application to work.  It doesn't appear to have any negative affects and we know for sure that the application database does not need that data type at all. 
Can someone verify that there are no requirements for SQL 2000 needing to have this data type?   They are worried that something within SQL may rely on it and we would find out the hard way in production possibly.
 
 

View 3 Replies View Related

Is Anyone Talk About The Core Differences Between SQL-Express And The Whole Edition?

Jul 14, 2007

should be detail ,I think it will be helpful to the newbirds such as me and the others.

View 3 Replies View Related

Poor Performance On Dual Xeon Machine

Jul 23, 2005

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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved