Search results for query: *

Deletion of database backup files during prime time caused a problem (100% CPU usage, users locked out of SQL - KB228206 seems to apply). Anybody aware if using the "WITH INIT" option to remove old backups may cause the same problem? Thanks.

We have recently increased the size of the log_buffer from 10MB to 20MB. Since then we have seen far more archive redo logs being created than before. The users are not aware of any additional work being done and the log buffer increase is the only obvious change that has been made. I cannot...

We are about to buy and install Lumigent LogExplorer. One of the options is to record "session login information". This uses SQL Profiler APIs and results are stored in a table. Has anyone who uses LogExplorer used this option, and noticed any performance issues? The system has up to 2500...

Looks like we are going to purchase this tool. One of the options is to "capture login information". The datasheet says this is done by Profiler APIs and stored in a table. Our query is - will this have a noticeable effect on performance? Have any other Tippers any opinions? If you use this, how...

We are seeting up some alerting mechanisms on a linux server running mysql. We have a programme that will search for text strings in files and alert us if it detects one. We could set it to look for ERROR or WARNING in the general or error log. Does anyone have any suggestions an anything...

We have set up a standby database on a different server and enabled automatic shipping of archive redo logs. This is working ok. The live database is backed up every night as a cold backup. Since the implementation of the standby database we have noticed that the database shutdown is...

Is it possible to keep an audit trail of commands issued through sqlplus. We have a system where several users have sqlplus access and I would like to be able to record what has been done through sqlplus without having to run auditting on the entire database.

How many mysql processes are started by default when mysql is started on linux?

I would like to be able to have a file created showing the output from the alert.tcl script. This would be to show whether it is an alert event or a warning event. Does anyone have any suggestions?

I have installed mysql 4.02 on redhat linux. I have created a user called mysql to administer the mysql installation. I can run mysqld_safe as the mysql user without any problems, however, when I try to run it as the root user with --user=mysql the process does not start and the following error...

Running SQL Profiler in prime time, extracting lots of data. It stopped itself, apparently running out of resources. Later, closing down SQL Profiler apaprently caused SQL to failover, which was not what was expected, or wanted. Any Tippers seen any similar problems? Thanks.

Our client has two SQL 2K Clustered servers (Srv_A and Srv_B), each running a different application. The applications interact with each other. SQL locks appear intermitently on Srv_B. These locks sometimes clear by themselves, or only after the user logs out of the application. They seem to...

I have installed Oracle Enterprise Manager and am trying to create an event. However for database events the only test available is database up/down. Is there something else I need to install to make the other tests available? Thanks Graham

How can I quickly check the total ammount of memory there is on a server?

We have recently moved an Oracle 8174 database from one solaris server to another. They are different types of server with different disks. However the database structure is the same. Is it advisable to run analyze against the tables to recompute the statistics now we are using the new machine?

We have been asked to look at SQL server performance of another server, and started monitoring the "\SQLServer:Buffer Manager\Buffer cache hit ratio" and the "\SQLServer:Cache Manager(_Total)\Cache Hit Ratio" counters. The first is around 99.xx. The second is around 65-68...

We have a database that was approx 35 GB in size. It was necessary to export the database off the server and then import it back again. This process reduced the size of the datafile to 19 GB. Is this effectively defragmenting the database and claiming back free space? Does anyone recommend...

Our system is a cluster, and has recently been failed over and back, we are not sure what else. Now the SQL Performance counters fail to start, apparently the objects do not exist. The counters can be defined. The alerts all seem Ok, as they have been started.

Our user has a "live" system and and a completely separate "test" system which should have the same disk layout etc. Should "master" & "msdb" be refreshed from "live" to "test" along with users' database or just the users' database?

On one of our databases, an insert of 50 rows takes 60-90 seconds for the first insert. The rows are then deleted. Subsequent inserts of the same data take almost no time, when repeated soon afterwards. If this sequence is repeated the next day, then the initial delay occurs again. All done...