Does enabling/disabling Data Execution Prevention have a performance
impact on SQL 2000 or SQL 2005?
For SQL best performance - how should I configure for:
Processor Scheduling:
Programs or Background services
Memory Usage:
Programs or System Cache
9  4418 
Hi
These setting will depend on what your system is doing. If you are solely
using it for SQL Server then there is little point in saving a large amount
of memory or processor for other tasks other than the OS, or if you have DTS
packages or other batch processes you would need to watch them. The exact
settings would need to be gained iteratively and monitored. Using the boost
priority for background services should have little effect if you are solely
using the system for SQL server, if it is a shared system then you could set
it, although it may have an impact when you need to access the system
quickly in an emergency. It would not only be SQL Server that gains from
setting background service priority. Depending on how many CPUs you have,
may allow you to set processor affinity, again this will depend on what your
system is doing and you could see an overall improvement in performance if
not all the CPUs are being used by SQL Server.
You may want to check out the articles and check lists on http://www.sql-server-performance.co...cles_audit.asp
John
"dunleav1" <jm*@dunleavyen terprises.comwr ote in message
news:11******** **************@ m79g2000cwm.goo glegroups.com.. .
Does enabling/disabling Data Execution Prevention have a performance
impact on SQL 2000 or SQL 2005?
For SQL best performance - how should I configure for:
Processor Scheduling:
Programs or Background services
Memory Usage:
Programs or System Cache
Thanks I'll check out the link.
The server sole use is sql server database.
There are no dts packages just sql statements executed via jdbc.
Hi
If that is the case you should be able to allocate most of the resources not
used by the OS to SQL Server.
John
"dunleav1" <jm*@dunleavyen terprises.comwr ote in message
news:11******** *************@h 48g2000cwc.goog legroups.com...
Thanks I'll check out the link.
The server sole use is sql server database.
There are no dts packages just sql statements executed via jdbc.
I have a process that I loads about 1000000 records into various tables
via jdbc.
With Sql server it takes about 35 minutes. If I use jtds or microsoft's
jdbc driver.
With Oracle it takes 5 minutes.
I have Oracle and Sql server configured on the same server. I stop the
other db vendor services when I run the process.Sql server is in simple
recovery mode and oracle in noarchivelog mode. They share the same raid
array configuration - raid 1/0.
Can Oracle's jdbc driver be that much better than Microsoft?
Hi
There can be many reasons for this to be slow not just the JDBC driver, you
may have contention for the discs with the different types of I/O and you
may have other poor configuration settings such as a poor choice of database
growth size, isolation level, or the code may not be the most optimal. You
don't say what the process is that loads this data, but look at using
something like BULK INSERT or possibly OPENROWSET instead of one insert
statement per row.
John
"dunleav1" <jm*@dunleavyen terprises.comwr ote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .
>I have a process that I loads about 1000000 records into various tables
via jdbc.
With Sql server it takes about 35 minutes. If I use jtds or microsoft's
jdbc driver.
With Oracle it takes 5 minutes.
I have Oracle and Sql server configured on the same server. I stop the
other db vendor services when I run the process.Sql server is in simple
recovery mode and oracle in noarchivelog mode. They share the same raid
array configuration - raid 1/0.
Can Oracle's jdbc driver be that much better than Microsoft?
John Bell wrote:
Hi
There can be many reasons for this to be slow not just the JDBC driver, you
may have contention for the discs with the different types of I/O and you
may have other poor configuration settings such as a poor choice of database
growth size, isolation level, or the code may not be the most optimal. You
don't say what the process is that loads this data, but look at using
something like BULK INSERT or possibly OPENROWSET instead of one insert
statement per row.
John
I've tried four different vendor jdbc drivers - ms, jtds, jnetdirect,
jturbo.
jtds is the fastest.
I have a raid 1/0 disk array - the entire db is loaded on the array
along with the os. Identical configuration as Oracle. The average disk
queue is 30% for sqlserver regardless fo driver. Network bandwidth is
at 15% on the nic.
The database is presized so there is no growoth occuring on the log or
application db, or tempdb.
The process that loads the data is a process written in java - it
basically does inserts as batch - as a stored procedure.
>
"dunleav1" <jm*@dunleavyen terprises.comwr ote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .
I have a process that I loads about 1000000 records into various tables
via jdbc.
With Sql server it takes about 35 minutes. If I use jtds or microsoft's
jdbc driver.
With Oracle it takes 5 minutes.
I have Oracle and Sql server configured on the same server. I stop the
other db vendor services when I run the process.Sql server is in simple
recovery mode and oracle in noarchivelog mode. They share the same raid
array configuration - raid 1/0.
Can Oracle's jdbc driver be that much better than Microsoft?
dunleav1 wrote:
I have a raid 1/0 disk array - the entire db is loaded on the array
along with the os. Identical configuration as Oracle.
Ideally, you want OS, db, logs, temp on separate physical drives, right?
Ed Murphy wrote:
dunleav1 wrote:
I have a raid 1/0 disk array - the entire db is loaded on the array
along with the os. Identical configuration as Oracle.
Ideally, you want OS, db, logs, temp on separate physical drives, right?
There is only one disk controller.
There are 6 disks configured within the array. The array is configured
RAID 1/0 (striped/mirror).
By sepearting everything on it's own disk you are "manually" striping
the OS, db, logs, temp from each other. Hardware striping is much
faster.
Ed Murphy wrote:
dunleav1 wrote:
I have a raid 1/0 disk array - the entire db is loaded on the array
along with the os. Identical configuration as Oracle.
Ideally, you want OS, db, logs, temp on separate physical drives, right?
There is only one disk controller.
There are 6 disks configured within the array. The array is configured
RAID 1/0 (striped/mirror).
By sepearting everything on it's own disk you are "manually" striping
the OS, db, logs, temp from each other. Hardware striping is much
faster. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sonny Grunter |
last post by:
I'm looking for configuration advice for a SQL Server. I have the
following hardware to work with:
1 Dell P4 2.66 GHz PC with 512 MB RAM and a 40GB IDE drive
2 Seagtate Barracuda 4.55GB SCSI drives (ST34572W) in an external bay
1 Adaptec 2940UW SCSI Controller
Windows 2000 Advanced Server
MSSQL 2000 Enterprise
|
by: prunoki |
last post by:
Hello,
I am an SQL server newbie. Our company has a massive application
written in PL/SQL. I need to port parts of it to SQL Server.
- Which SQL server version should I choose, to have a reasonable chance
of porting?
- Could you recommend any best practices, tools? I use Toad for SQL
development on Oracle, I am looking for something similar for SQL
|
by: Danieltbt05 |
last post by:
just installed SQL server 2000 and using my client , i can't locate
the server. I used SQL query analyzer to search but no servers were
found. Error message is as below
Server : Msg17,level 16, state1
SQL server does not exist
or denied access.
|
by: coosa |
last post by:
Hi,
I was installing SQL Server on my machine and during installation my PC
freezed. It happens frequently on my machine. So i tried after
restarting to install it again and since then i always get the same
error message:
"An error occurred while creating one or more registry entries. Please
see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a
low registry quota condition"
I have tried to clean the registry and i...
|
by: sara |
last post by:
Hi All,
I was able to connect to MS SQL Server 2005 on my computer but after a
while I can not. When I want to connect to it using MS SQL Server
Management Studio I got this error:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider,...
| | |
by: Thanks |
last post by:
Two Windows 2003 server,
one with SQL 2005 server,
another with SQL Express.
Is it possible to copy databases from SQL 2005 to SQL Express?
Thanks.
|
by: Olegus |
last post by:
Hello,
in order to perform backup/restore MSSQL database using SMO, one needs
to reference several namespaces in a backup class :
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
Unfortunately, MSSQL 2005 and MSSQL Express keep them in different
place.
For MSSQL2005 they are located in C:\Program Files\Microsoft SQL Server
\90\SDK\Assemblies and for MSSQL Express you can find them in C:
|
by: Lee T. Hawkins |
last post by:
I am having a number of problems over the last two full days trying to get
an ASP.NET 2.0 application to connect to a SQL Server 2005 database...
First off, I built this application w/ Visual Studio 2005 SP1 and had it
working perfectly on my Windows XP machine on SQL Server 2005 Express. I
decided to publish this application to a test development server (with both
the SQL and IIS servers on the same box) running on:
Windows Server...
|
by: TerpZebra |
last post by:
I am having difficulty connecting to SQL Server 2000 on one of our
servers via a VB6 program on Vista. I can connect fine to a different
server, but it gives me the following error with the server in
question:
"Unable to connect to database. Please check your internet connection
Error# -2147467259
SQL Server does not exist or
access denied"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
