f



Database server job (QZDASOINIT) performance anomaly

We have several Windows servers (2003) around the 
country that all issue the same set of SQL queries 
against our iSeries; only the value of a location 
parameter changes from one remote server to another.

Following an IPL of the iSeries, the Windows server in 
one location hangs when running the queries.  Queries 
that used to run in a couple of minutes, and that 
continue to run for that duration in the other remote 
locations, now run 15 minutes or longer, sometimes for 
hours.  Nothing has changed on any of the Windows servers.

The last time this happened (we only IPL a couple of 
times a year), the sysadmin for the remote location 
experiencing the slowdown moved the functionality to a 
"virtual server".  It was subsequently moved back to 
the original server, and it ran fine until the most 
recent IPL on Monday.

I'm not sure where to start with a performance analysis 
of this particular server's QZDASOINIT job - I glanced 
at the performance subsection in the system management 
section of the iSeries information center, and it was 
like drinking from a firehose.  Any suggestions?

Thanks in advance.
0
jonball (677)
1/3/2008 8:17:19 PM
comp.sys.ibm.as400.misc 9219 articles. 4 followers. Post Follow

4 Replies
1017 Views

Similar Articles

[PageSpeed] 4

> We have several Windows servers (2003) around the country that all issue 
> the same set of SQL queries against our iSeries; only the value of a 
> location parameter changes from one remote server to another.

> Following an IPL of the iSeries, the Windows server in one location 
> hangs when running the queries.  Queries that used to run in a couple of 
> minutes, and that continue to run for that duration in the other remote 
> locations, now run 15 minutes or longer, sometimes for hours.  Nothing 
> has changed on any of the Windows servers.

May something has changed on iSeries server...


> The last time this happened (we only IPL a couple of times a year),

IPLing twice a year may be a good reason to use ipl itself to apply ptf:
sometimes sql ptfs may change sql behavior a lot :-|
(I've opened several "pmr" related to sql problems after some ptfs...)


> the 
> sysadmin for the remote location experiencing the slowdown moved the 
> functionality to a "virtual server".  It was subsequently moved back to 
> the original server, and it ran fine until the most recent IPL on Monday.

If iSeries is at V5R4 then it could be rather normal:
after every ipl you loose the "plan cache".
And you loose all temporary indexes that at V5R4 may be built 
"automatigically".
You have to wait for the system to rebuild those indexes and to "build" 
plan cache again. For the indexes, as they are in Index Advisor, it 
could be better to build them instead of let the system do it for you...


> I'm not sure where to start with a performance analysis of this 
> particular server's QZDASOINIT job - I glanced at the performance 
> subsection in the system management section of the iSeries information 
> center, and it was like drinking from a firehose.  Any suggestions?

Look at the "Database" section:
if at V5R4 than Index Advisor and Plan Cache may help you very quickly ;-)
If you are at V5R3 or less I'd collect database monitors for those 
queries and check them with Visual Explain and the related queries on 
dbmon itself.


> Thanks in advance.

HTH
	Stefano P.

-- 
"Niuna impresa, per minima che sia,
  pu� avere cominciamento e fine senza queste tre cose:
  e cio� senza sapere, senza potere, senza con amor volere"
                 [Anonimo fiorentino, XIV sec.]

(togliere le "pinzillacchere" dall'indirizzo email  ;-)
0
procstef (32)
1/3/2008 9:33:29 PM
On Jan 3, 4:33=A0pm, "Stefano P." <procs...@pinzillacchere.yahoo.it>
wrote:
> > We have several Windows servers (2003) around the country that all issue=

> > the same set of SQL queries against our iSeries; only the value of a
> > location parameter changes from one remote server to another.
> > Following an IPL of the iSeries, the Windows server in one location
> > hangs when running the queries. =A0Queries that used to run in a couple =
of
> > minutes, and that continue to run for that duration in the other remote
> > locations, now run 15 minutes or longer, sometimes for hours. =A0Nothing=

> > has changed on any of the Windows servers.
>
> May something has changed on iSeries server...
>
> > The last time this happened (we only IPL a couple of times a year),
>
> IPLing twice a year may be a good reason to use ipl itself to apply ptf:
> sometimes sql ptfs may change sql behavior a lot :-|
> (I've opened several "pmr" related to sql problems after some ptfs...)
>
> > the
> > sysadmin for the remote location experiencing the slowdown moved the
> > functionality to a "virtual server". =A0It was subsequently moved back t=
o
> > the original server, and it ran fine until the most recent IPL on Monday=
..
>
> If iSeries is at V5R4 then it could be rather normal:
> after every ipl you loose the "plan cache".
> And you loose all temporary indexes that at V5R4 may be built
> "automatigically".
> You have to wait for the system to rebuild those indexes and to "build"
> plan cache again. For the indexes, as they are in Index Advisor, it
> could be better to build them instead of let the system do it for you...
>
> > I'm not sure where to start with a performance analysis of this
> > particular server's QZDASOINIT job - I glanced at the performance
> > subsection in the system management section of the iSeries information
> > center, and it was like drinking from a firehose. =A0Any suggestions?
>
> Look at the "Database" section:
> if at V5R4 than Index Advisor and Plan Cache may help you very quickly ;-)=

> If you are at V5R3 or less I'd collect database monitors for those
> queries and check them with Visual Explain and the related queries on
> dbmon itself.
>
> > Thanks in advance.
>
> HTH
> =A0 =A0 =A0 =A0 Stefano P.
>
> --
> "Niuna impresa, per minima che sia,
> =A0 pu=F2 avere cominciamento e fine senza queste tre cose:
> =A0 e cio=E8 senza sapere, senza potere, senza con amor volere"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0[Anonimo fiorentino, XIV sec.]
>
> (togliere le "pinzillacchere" dall'indirizzo email =A0;-)

Jon, curious, how you running these, TELNET (port 23), GUI ??  Batch
or Interactive Wonder if the app is getting an exclusive LCKW.
0
jkingsley1 (182)
1/4/2008 3:17:07 PM
jacko wrote:
> On Jan 3, 4:33 pm, "Stefano P." <procs...@pinzillacchere.yahoo.it>
> wrote:
>>> We have several Windows servers (2003) around the country that all issue
>>> the same set of SQL queries against our iSeries; only the value of a
>>> location parameter changes from one remote server to another.
>>> Following an IPL of the iSeries, the Windows server in one location
>>> hangs when running the queries.  Queries that used to run in a couple of
>>> minutes, and that continue to run for that duration in the other remote
>>> locations, now run 15 minutes or longer, sometimes for hours.  Nothing
>>> has changed on any of the Windows servers.
>> May something has changed on iSeries server...
>>
>>> The last time this happened (we only IPL a couple of times a year),
>> IPLing twice a year may be a good reason to use ipl itself to apply ptf:
>> sometimes sql ptfs may change sql behavior a lot :-|
>> (I've opened several "pmr" related to sql problems after some ptfs...)
>>
>>> the
>>> sysadmin for the remote location experiencing the slowdown moved the
>>> functionality to a "virtual server".  It was subsequently moved back to
>>> the original server, and it ran fine until the most recent IPL on Monday.
>> If iSeries is at V5R4 then it could be rather normal:
>> after every ipl you loose the "plan cache".
>> And you loose all temporary indexes that at V5R4 may be built
>> "automatigically".
>> You have to wait for the system to rebuild those indexes and to "build"
>> plan cache again. For the indexes, as they are in Index Advisor, it
>> could be better to build them instead of let the system do it for you...
>>
>>> I'm not sure where to start with a performance analysis of this
>>> particular server's QZDASOINIT job - I glanced at the performance
>>> subsection in the system management section of the iSeries information
>>> center, and it was like drinking from a firehose.  Any suggestions?
>> Look at the "Database" section:
>> if at V5R4 than Index Advisor and Plan Cache may help you very quickly ;-)
>> If you are at V5R3 or less I'd collect database monitors for those
>> queries and check them with Visual Explain and the related queries on
>> dbmon itself.
>>
>>> Thanks in advance.
>> HTH
>>         Stefano P.
>>
>> --
>> "Niuna impresa, per minima che sia,
>>   pu� avere cominciamento e fine senza queste tre cose:
>>   e cio� senza sapere, senza potere, senza con amor volere"
>>                  [Anonimo fiorentino, XIV sec.]
>>
>> (togliere le "pinzillacchere" dall'indirizzo email  ;-)
> 
> Jon, curious, how you running these, TELNET (port 23), GUI ??  Batch
> or Interactive Wonder if the app is getting an exclusive LCKW.

The Windows server establishes (I believe) an OLE-DB 
(but it could be ODBC) connection to the iSeries.  It 
then passes the complex dynamic SQL statement to the 
database server program (QZDASOINIT), which seemingly 
returns the result set to the remote server.

I think I may have solved the problem.  Based on 
Stefano's comments, I did a web search on "plan cache", 
and that led me to an IBM Information Center page, 
which confirmed that dynamic SQL statements' access 
plans are cleared from the plan cache during an IPL. 
So, I copied the server's SQL statement and embedded it 
in an SQLRPGLE program, which declares a cursor for the 
query, opens it, then closes it.  The next time they 
fired up the server connection to the iSeries, it ran 
the query in the expected 2-4 minutes.

The ideal solution, I think, would be for me to code 
their SQL query as a stored procedure, and they would 
get rid of their dynamic SQL statement passed to the 
iSeries, and replace it with a call to the stored 
procedure.  The SP would contain the access plan, and 
that would persist across IPLs.  That won't happen, for 
internal political reasons.  The next-best solution is 
to keep this "dummy" program containing their SQL query 
in a cursor definition, and perhaps call that program 
in an autostart job when the system IPLs.
0
jonball (677)
1/5/2008 6:27:29 AM
[cut]
> The ideal solution, I think, would be for me to code their SQL query as 
> a stored procedure, and they would get rid of their dynamic SQL 
> statement passed to the iSeries, and replace it with a call to the 
> stored procedure.  The SP would contain the access plan, and that would 
> persist across IPLs.  That won't happen, for internal political 
> reasons.  The next-best solution is to keep this "dummy" program 
> containing their SQL query in a cursor definition, and perhaps call that 
> program in an autostart job when the system IPLs.

On V5R4 you may still have the temporary indexes created automatically 
by the system first time you run the query after ipl:
don't forget to check Index Advisor and Plan Cache on the Database 
section of Navigator, may be you could find that your queries need some 
indexes...


Regards
	Stefano P.

-- 
"Niuna impresa, per minima che sia,
  pu� avere cominciamento e fine senza queste tre cose:
  e cio� senza sapere, senza potere, senza con amor volere"
                 [Anonimo fiorentino, XIV sec.]

(togliere le "pinzillacchere" dall'indirizzo email  ;-)
0
procstef (32)
1/5/2008 4:02:21 PM
Reply:

Similar Artilces:

Server Hardware and Database Performance
I'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 Servers
Eolparts 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 link
http://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 performance
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. 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 Jobs
Information 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 server
Hi 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 issues
Hi 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 server
I'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 Manager
Hi, 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 server
Hi, 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 Study
Hi - 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 1994
http://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 Ser
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 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...

Web resources about - Database server job (QZDASOINIT) performance anomaly - comp.sys.ibm.as400.misc

Performance - Wikipedia, the free encyclopedia
A performance , in performing arts , generally comprises an event in which a performer or group of performers behave in a particular way for ...

Julie Stevanja of Stylerunner is speaking at PERFORMANCE INSIGHTS in Sydney this week
Data will be what gives businesses the edge in the 21st century. No aspect of business will be untouched, from decision-making and corporate ...

From Performance Art to Conflict Journalism
... herself more than once, evolving from art student to artist’s model to performer and impresario of a kind of underground bohemian performance-art ...

Finnish Startup Beats Google, Microsoft and Amazon In Cloud Hosting Performance
... performer in a new study of top European Cloud Service Providers by industry consulting agency Cloud Spectator. “We have long identified performance ...

Lupita Nyong'o’s 'Star Wars' character may have been CGI, but people don't realize just how much work ...
Taking a cue from the original "Star Wars" trilogy, "The Force Awakens" relied mostly on practical effects — except for Lupita Nyong'o's character, ...

Utility-Scale PV Projects: First US Statistical Performance Analysis
... photovoltaic operating projects whose empirical AC capacity factors differ by more than a factor of two, however. Understanding the performance ...

Man catches fire during performance at school pep rally in Florida
cleveland.com Man catches fire during performance at school pep rally in Florida (video) cleveland.com DELRAY BEACH, Florida — Eight people ...

Meet the iPhone SE, which packs iPhone 6S performance in a 4-inch body
... it, has an A9 chip and M9 coprocessor, which means it has double the speed of a 5S and is three times faster when it comes to graphics performance. ...

Dark Souls III on Xbox One has already been put through the performance paces
... a little early, meaning that initial impressions are already surfacing. Digital Foundry, many people's go-to resource on video game performance, ...

The Passion Live's Best, Worst, and Most Confusing Performances
New York Times The Passion Live's Best, Worst, and Most Confusing Performances E! Online "Hey Jesus, can I get a selfie?" We're genuinely ...

Resources last updated: 3/24/2016 12:38:29 PM