Server Hardware and Database PerformanceI'm using MySQL5 to do some quite slow queries, and I am interested to
know how much of an improvement I will be able to achieve by using
better hardware.
The slowest query does a 20 table LEFT JOIN on well-indexed tables with
between 1000-10000 rows. It takes about 5 seconds to complete without
any other load, which is the most I can really cope with.
The server PC is a fairly bog-standard Dell machine (2Ghz Celeron, 512Mb
RAM) running XP Pro, and I am considering using a dual-processor (~3GHz)
machine instead.
I would hope to be able to reduce the execution time of t...
IBM Servers, HP Servers and Sun Enterprise ServersEolparts a.k.a. your favorite "Sun Spot" on the internet offers you
only the best services on the widest selection of brand name
remanufactured computer hardware. Save up to 80% off the original list
price of all Sun Products and Parts! eolparts is a premier global
supplier of Sun workstations, Sun Servers and Internet infrastructure
hardware.
We provide our customers with the highest quality refurbished products
paired with an unmatched host of professional services. Our world-
class customer service is pivotal in the way we do business by putting
our clients=92 needs first; we focus on the end users=92 desired result
and work to make that happen in the most cost efficient manner.
For more information visit at: - http://www.eolparts.com/
...
databases.oracle.server job linkhttp://www.jobbankdata.com
http://www.jobbankdata.com/index.htm
http://www.jobbankdata.com/type-of-jobs.htm
http://www.jobbankdata.com/find-job.htm
http://www.jobbankdata.com/result.htm
http://www.jobbankdata.com/create-app.htm
http://www.jobbankdata.com/create-cv.htm
http://www.jobbankdata.com/interview.htm
http://www.jobbankdata.com/site.htm
On Mar 12, 10:29 am, "good_online_jobs" <good_online_j...@yahoo.com>
wrote:
> http://www.jobbankdata.comhttp://www.jobbankdata.com/index.htmhttp://www.jobbankdata.com/type-of-jobs.htmhttp://www.jobbankdata.com/find-job.htmhttp://www.jobbankdata.com/result.htmhttp://www.jobbankdata.com/create-app.htmhttp://www.jobbankdata.com/create-cv.htmhttp://www.jobbankdata.com/interview.htmhttp://www.jobbankdata.com/site.htm
Would you please stop violating the newsgroup terms of use by posting
this useless non-Oracle related crapola.
Sites supported by such unethical postings are not work visiting.
-- Mark D Powell --
...
number of databases in SQL server and performanceDoes the number of databases present in a SQL Server instance impact
the performance of the instance? with all else being equal two
identical servers that have one 5 databases and the other 65 would
they perform the same under the same load condition assuming 60 of
them are just taking space? Of course there's plenty of storage space
left on both.
GM (gentian.metaj@trustasc.com) writes:
> Does the number of databases present in a SQL Server instance impact
> the performance of the instance? with all else being equal two
> identical servers that have one 5 databases and the other 65 would
> they perform the same under the same load condition assuming 60 of
> them are just taking space? Of course there's plenty of storage space
> left on both.
If the 60 dormant databases are in autoclose, and no one touches them no.
If they are not in autoclose, but still untouched, they may take up
some memory, but it is not likely to be noticeable in practice.
What matters a little is if people access the server with Enterprise
Manager 2000 or SQL Server Mgmt Studio 2008, as they look into to every
database when you browse the database tree. This means that if the databases
are in autoclose, they have to be started everytime, which definitely
will be noticeable for the user. If they are not in autoclose, the few
queries are not likely to be a concern, unless the user is on a slow
connection.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Links fo...
Jobs Jobs JobsInformation Technology - Science � Sales - Marketing � Finance
We have hundreds of jobs listed at www.parafind.com. Open your FREE
account today to apply.
Oracle, Java, Microsoft, sun, sales, Administration, Internet,
Object-oriented design, framework, law, architecture, J2EE, .NET,
unix, linux, C++, Linux, Networking, VB, ASP, IIS, Websphere,
Security, computer, Pharmaceutical, Telecom, database, DB2, SQL,
AS400, mainframe, Technical, Customer, Support, Data Model, UML,
Erwin, sybase, Insurance, Windows, Office, Word, Excel, PowerPoint
...
QUESTION: Performance issue on *one* database on a serverHi there.
I'm on a SQL 2000 SP4 machine.
This is a development machine, with only a couple of small databases on
it.
Yesterday I needed to recover a table from backup, so I went through
the following process:
-Used 'Create SQL script' to generate a create db statement from the
current db.
-Changed the db name, and all file paths to not conflict with the
current db.
-Created a new db in a new directory with this script.
-Restored last night's backup from the 'real' db to the new one.
-Went into the 'recovered' database, located the table which needed to
be restored, and renamed it to "<table_name>_RECOVER"
-Used DTS to transfer that table to the 'real' database
-Truncated the table to be recovered
-did a 'Insert into select * from' statement to recover the records.
-dropped the table that I had copied in via DTS. This table was small -
8000 rows or so.
The database seemed fine at the time.
Now (the next morning) I am finding that performance of the 'real'
database is agonizingly slow. Even doing a 'select count (*) from <a
small table> simply does not return a result. the 'processing' globe
icon spins merrily away, and I get no result set.
However, the same query, submitted against the 'recovered' database
(the one I restored in order to get the data I required) responds
instantly, as it should.
These databases are both hanging off the same named instance of this
server (...
Lotus Notes server performance on very very big databases: hardware issuesHi
I have a really big Notes database (about 600.000 documents) on a
Domino 6 server, with about 70 concurrent users.
The server machine has 2 Intel Xeon processors at 2.4GHZ with 2GB RAM,
running Windows 2000 Server.
We are having some performance problems. Do you think we can do
something to the server to improve performance? Doubling the RAM would
help? Does Notes take advantage of the dual processors if there is just
one big database?
Thanks,
Toni
On 2006-07-07, ToniLou <tonilounavarro@gmail.com> wrote:
> We are having some performance problems. Do you...
SATA performance vs standard IDE for small database serverI'm looking at building a small database box for departmental use and
am curious if anyone has looked into if SATA would work better than
standard IDE for an application with a good number of simultaneous
read/write requests. There's a box doing something similar right now
in the office with regular IDE and I am very dissatisfied with its
performance. At certain times of the day it'll seem to freeze (even
in a shell!) for 2-3 seconds while it processes a lot of drive I/O.
Is this partially alleviated with SATA, or not really?
SCSI would be the way to go, but it's no...
Server to server = Server client to server?For a server to server connection, is the connecting server considered
as a client of the accepting server or is it not?
I have the following classes:
Connection <--- base class of the following two
ClientConnection <--- client
ServerConnection <--- server
ServerClientConnection <--- server as a client of another server.
But then I came across something that states "A client is anything
connected to a server that is not another client".
Comments please...
Just remember! Server ( programm ) is always listening a connections!!!
- wrote:
&g...
Estimating performance on an OLAP database (virtualization vs. server install)Hi all,
We're trying to test DB2's performance for an OLAP data warehouse.
We went with a column-store based approach after loading using a row-
store approach generated over 2 million rows for just a single month's
worth of data.
We're using Alphablox as the cubing engine, but we have found that
queries take several minutes to complete, which is worrying our
developers because it would render the application unusable. OLAP is
supposed to let the end users freely adjust their analysis but they
won't do so if drilling down on 1 dimension takes such a long time.
We're trialling with 1 month of data, which gives a fact table with:
450k rows
And each row has about 200 columns (it's an engineering analysis so
there are lots of parameters)
Currently our testing environment is a VMWare running Win2k3 w/ DB2
DWE 9.5 installed, 3.5GB ram, 80GB disk.
In comparison, the target production environment will have 4 CPU cores
and hopefully 10 disks so we can make more containers for the data and
make use of parallelism. However, would the 5-7 minute queries get
reduced to at sub-second responses? What other tuning tasks can we
perform? We also plan on using Query Patroller to build MQTs to
improve OLAP performance, but that is later in the project - currently
we need to be able to address the > 5 minute query response.
Appreciate any advice :)
...
Database name not found in the Edit job step in SQL Server Enterprise ManagerHi,
I need help. I transferred my database from one server to another by
using attach detach process.I created all the jobs which existed in the
old server in the new server. Everything looked fine but a couple of
jobs is a giving me some problems. When I try to edit the job step I
could see that the database dropdown list doesn't contain the database
name(which I transferred from the old server)
Does anyone have any idea about it.
Thanks
Arun
(arunkumar_m2001@yahoo.com) writes:
> I need help. I transferred my database from one server to another by
> using attach detach process.I created all the jobs which existed in the
>
> old server in the new server. Everything looked fine but a couple of
> jobs is a giving me some problems. When I try to edit the job step I
> could see that the database dropdown list doesn't contain the database
> name(which I transferred from the old server)
>
>
> Does anyone have any idea about it.
Have you tried simply closing down Enterprise Manager and starting it
again? I did a quick test, and it appears that the job-step dialogue
caches the database list, so it may not have seen the new database yet.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
...
AS400 as SQL Server Linked serverHi,
I'm trying to set up DB2 on AS400 as a linked server on SQL Server.
Everything works ok, but, when I try to run an UPDATE, it gives me an
error (OLE/DB Provider 'MSDASQL' IRowsetChange::SetData returned
0x80004005). I've searched a lot on the internet, I've tried some
solutions but without success.
I'm using SQLServer 2000 and Client Access 5 release 1.
Is there any solution or workaround ?
Thanks in advance
Massimo
...
IBM Informix Database Server a Forrester Total Economic Impact StudyHi - Is there anybody in informix groups able to download this study
using the following link ?
I filled up the profile (registration form) 10 times, but was not able
to download the PDF. The browser is keep on trying, trying .....
If any one is able to download, can you please forward the pdf to my
email address chavan1@gmail.com ?
--Chavan
This is a multi-part message in MIME format.
--------------010901090102040604080601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Hello.
You could contact Mr Marti Avery ove...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324357704)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324357704)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
Reports, MS Reporting Services).
5+yrs exp advance MS Access knowledge and skills.
5+yrs exp writing, supporting, and optimizing stored
procedures.
5+yrs exp supporting a multi-tiered development platform,
and have a thorough understanding of performance and
applications tuning, capacity planning, database maintenance
procedures, and security strategies.
5+yrs exp in ASP.Net, ASP, COM, Visual Basic, VBScript,
and/or JavaScript.
5+yrs exp working with all phases of the System Development
Life Cycle (SDLC), including working closely with business
analysts and software developer to ensure a clear
understanding of system requirements.
Microsoft's SQL Server 2000 DBA c...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324914403)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324914403)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
Reports, MS Reporting Services).
5+yrs exp advance MS Access knowledge and skills.
5+yrs exp writing, supporting, and optimizing stored
procedures.
5+yrs exp supporting a multi-tiered development platform,
and have a thorough understanding of performance and
applications tuning, capacity planning, database maintenance
procedures, and security strategies.
5+yrs exp in ASP.Net, ASP, COM, Visual Basic, VBScript,
and/or JavaScript.
5+yrs exp working with all phases of the System Development
Life Cycle (SDLC), including working closely with business
analysts and software developer to ensure a clear
understanding of system requirements.
Microsoft's SQL Server 2000 DBA c...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324633023)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324633023)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324614403)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324614403)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324338733)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324338733)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324914403)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324914403)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324932409)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324932409)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
Reports, MS Reporting Services).
5+yrs exp advance MS Access knowledge and skills.
5+yrs exp writing, supporting, and optimizing stored
procedures.
5+yrs exp supporting a multi-tiered development platform,
and have a thorough understanding of performance and
applications tuning, capacity planning, database maintenance
procedures, and security strategies.
5+yrs exp in ASP.Net, ASP, COM, Visual Basic, VBScript,
and/or JavaScript.
5+yrs exp working with all phases of the System Development
Life Cycle (SDLC), including working closely with business
analysts and software developer to ensure a clear
understanding of system requirements.
Microsoft's SQL Server 2000 DBA c...
US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324633023)US-TX-Austin: Database Admin, SQL Server 2000, performance tuning, Access; 8M (45324633023)
===========================================================================================
Position: Database Admin
Reference: SMC01703
Location: Austin TX
Duration: 8M
Skills: 5+yrs exp as SQL Server DBA in a web environment utilizing
SQL Server 2000.
5+yrs exp in performance tuning, DTS, SQL Server clustering,
Replication, and monitoring of SQL Server.
2+yrs exp working with reporting tool (MS Access, Crystal
...
Understanding,Performance Tuning Theory,for IBM OS/2 LAN Server,Document Number GG24-4430-00,November 1994http://www.redbooks.ibm.com/redbooks/pdfs/gg244430.pdf
On Feb 10, 12:41 pm, Louis Ohland <ohl...@charter.net> wrote:
> http://www.redbooks.ibm.com/redbooks/pdfs/gg244430.pdf
http://groups.google.com/group/comp.sys.ibm.ps2.hardware/browse_thread/thread/9397ec08e5d3d5a6/52f64e1ded21f320?lnk=gst&q=IBM+OS%2F2+LAN+Server+tuning&rnum=2#52f64e1ded21f320
This is the 1994 version. The title is so long it pushes it way to the
right.
Dan O wrote:
> On Feb 10, 12:41 pm, Louis Ohland <ohl...@charter.net> wrote:
>> http://www.redbooks.ibm.com/redbooks/pdfs/gg244430.pdf
>
>
> http://groups.google.com/group/comp.sys.ibm.ps2.hardware/browse_thread/thread/9397ec08e5d3d5a6/52f64e1ded21f320?lnk=gst&q=IBM+OS%2F2+LAN+Server+tuning&rnum=2#52f64e1ded21f320
>
...
MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting SerMicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000
Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL
Server 2000 Databases v1.1, SQL Server 2000 Reporting Services,
(Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no
dongles, no activations, etc ... needed ! ] (free donge)! No time
limitation!
CD NR 4203 MicroSoft SQL Server 2000 4in1
CD NR 9452 Microsoft SQL Server 2000 Service Pack 2
CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs]
CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit
CD NR 13 424 TransTrainer for Designing Microsoft SQL Server 2000
Databases v1.1
CD NR 14 688 SQL Server 2000 Reporting Services (c) Microsoft
CD NR 15 412 SQL Server 2000 Reporting Services Enterprise (c)
Microsoft
please send e-mail, to ola2@mail.gr, zorba@mail.gr
...
File Server Database Apps and SQL Server?Like a lot of database developers, I often choose Jet for the back-
end. I'm starting to worry about what will happen when Jet is
deprecated. Ostensibly, Jet users like me must switch to SQL Server
(or MSDE / SQL Express), but there's something I just don't
understand.
Without Jet, how will we create file server database applications? In
other words, how will we create multi-user apps which use a file
server to share data and don't require a database server? I've seen
many discussions of Access vs. SQL Server, but I've never seen this
question addressed head-on. I can speculate on three possible answers,
but I'm not sure which one Microsoft intends:
In a Jet-less world,
1) there will be no file server database apps, only database server
apps.
2) there will be file server apps implemented somehow with SQL Server.
3) there will be file server apps, but Microsoft will cede this niche
to its competitors; thus, we will use neither Jet nor SQL Server, but
some other product, to implement them.
If anyone knows where things are going, I'd be grateful if you share
your understanding.
-TC
TC wrote:
> Like a lot of database developers, I often choose Jet for the back-
> end. I'm starting to worry about what will happen when Jet is
> deprecated. Ostensibly, Jet users like me must switch to SQL Server
> (or MSDE / SQL Express), but there's something I just don't
> understand.
>
> Without Jet, how will we create file s...