Moving Distribution database from an instance to antother does increase performance ?
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]
Answer Question
| March 15, 2010 10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]
Answer Question
| March 15, 2010 10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication
Running SQL Server 2000 and 2005 simultaneously
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?
Answer Question
| March 12, 2010 6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?
Answer Question
| March 12, 2010 6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005
Running a performance baseline trace on a SQL server
When you are running a performance baseline trace on a SQL server, how long do you typically run the trace? Or, do you run multiple traces at various times of the day?
Answer Question
| October 14, 2008 6:48 PM
Performance/Tuning, SQL Server, SQL Server performance, Trace
When you are running a performance baseline trace on a SQL server, how long do you typically run the trace? Or, do you run multiple traces at various times of the day?
Answer Question
| October 14, 2008 6:48 PM
Performance/Tuning, SQL Server, SQL Server performance, Trace
execution plan is same even though it takes 10 times longer to run
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!
Answer Question
| March 10, 2008 5:07 AM
Execution Plan, Indexes, Performance/Tuning
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!
Answer Question
| March 10, 2008 5:07 AM
Execution Plan, Indexes, Performance/Tuning
Performance Tracking of Stored Procedures
we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each called subprogram, due to the [...]
Answer Question
| February 27, 2008 7:07 PM
.NET applications, COBOL, COBOL stored procedures, CPU usage, MIPS, Performance management, Performance/Tuning, Stored Procedures
we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each called subprogram, due to the [...]
Answer Question
| February 27, 2008 7:07 PM
.NET applications, COBOL, COBOL stored procedures, CPU usage, MIPS, Performance management, Performance/Tuning, Stored Procedures
Database Admin…
Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did… nor did I. [...]
Answer Question
| December 20, 2007 3:37 PM
DBA, naming conventions, Performance/Tuning, Relation Database, Security, SQL
Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did… nor did I. [...]
Answer Question
| December 20, 2007 3:37 PM
DBA, naming conventions, Performance/Tuning, Relation Database, Security, SQL
media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
moving datafiles to different locations
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide me. Regards.
Answer Question
| March 26, 2007 12:18 PM
Backup & recovery, Performance/Tuning
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide me. Regards.
Answer Question
| March 26, 2007 12:18 PM
Backup & recovery, Performance/Tuning
ORA-12535
My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote databases is successful.Local users connected directly to the Live [...]
Answer Question
| October 27, 2006 5:44 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows
My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote databases is successful.Local users connected directly to the Live [...]
Answer Question
| October 27, 2006 5:44 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows
Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we’re using now for the server B the alias we’ve used for [...]
Answer Question
| November 1, 2006 11:28 AM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we’re using now for the server B the alias we’ve used for [...]
Answer Question
| November 1, 2006 11:28 AM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
error in connection between oracle8i&developer2000
I’m installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I’m installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error “TNS could not resolve.” Please provide a solution. Can I use Oracle8i Enterprise and Developer 2000 on the [...]
Answer Question
| February 4, 2009 4:46 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Desktops, Interoperability, Management, Microsoft Windows, Oracle, Oracle 8i, Oracle administration, OS, Performance/Tuning, Servers, Software, SQL, SQL Server
I’m installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I’m installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error “TNS could not resolve.” Please provide a solution. Can I use Oracle8i Enterprise and Developer 2000 on the [...]
Answer Question
| February 4, 2009 4:46 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Desktops, Interoperability, Management, Microsoft Windows, Oracle, Oracle 8i, Oracle administration, OS, Performance/Tuning, Servers, Software, SQL, SQL Server
Oracle Application or Database on its own server.
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]
Answer Question
| July 14, 2006 10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]
Answer Question
| July 14, 2006 10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Answer Question
| July 11, 2006 12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Answer Question
| July 11, 2006 12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
PL/SQL performance tuning…
I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the tables from the [...]
Answer Question
| June 26, 2008 1:48 PM
Oracle 10g, Performance/Tuning, SQL
I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the tables from the [...]
Answer Question
| June 26, 2008 1:48 PM
Oracle 10g, Performance/Tuning, SQL
inserts through a database link
Hello every body. Here I go again… Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to the second [...]
Answer Question
| March 31, 2006 10:13 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Installation, Migration, Oracle, Oracle 8i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows, XML
Hello every body. Here I go again… Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to the second [...]
Answer Question
| March 31, 2006 10:13 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Installation, Migration, Oracle, Oracle 8i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows, XML
Using optimizer hints in Forms
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look [...]
Answer Question
| March 28, 2006 12:28 PM
Oracle, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle development, Performance/Tuning, Security, SQL
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look [...]
Answer Question
| March 28, 2006 12:28 PM
Oracle, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle development, Performance/Tuning, Security, SQL
SQL Server worst practices
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers [...]
Answer Question
| July 26, 2005 12:16 PM
Administration, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Development, Hardware, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Version 7 and earlier
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers [...]
Answer Question
| July 26, 2005 12:16 PM
Administration, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Development, Hardware, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Version 7 and earlier
Upgrade to SQL Server 2005 sooner or later?
Hello, I’m the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization’s plans? 58% delays had no [...]
Answer Question
| July 22, 2005 10:19 AM
Administration, Architecture/Design, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Implementation, Installation/Upgrade, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier
Hello, I’m the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization’s plans? 58% delays had no [...]
Answer Question
| July 22, 2005 10:19 AM
Administration, Architecture/Design, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Implementation, Installation/Upgrade, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier
File transfer to the iSeries problem.
I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following error cwbtf0023 – pc file description file was not specified or is empty The file is not empty. [...]
Answer Question
| December 9, 2011 10:11 AM
AS/400, Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following error cwbtf0023 – pc file description file was not specified or is empty The file is not empty. [...]
Answer Question
| December 9, 2011 10:11 AM
AS/400, Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Is *JOBCTL needed to view job logs?
I have read IBM’s Security manual and Work Management manual and I know that *JOBCTL is needed to change job priorities and other things for jobs on the system, but I do not see any statements that say *JOBCTL is needed to view the job logs of other user’s jobs on the system. Does anyone [...]
Answer Question
| October 25, 2010 2:09 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
I have read IBM’s Security manual and Work Management manual and I know that *JOBCTL is needed to change job priorities and other things for jobs on the system, but I do not see any statements that say *JOBCTL is needed to view the job logs of other user’s jobs on the system. Does anyone [...]
Answer Question
| October 25, 2010 2:09 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
