New answers tagged


Capture this: Select instance_name As Database_Name, cntr_value As TranSec From sys.dm_os_performance_counters where counter_name = 'Transactions/sec' And instance_name <> '_Total' Order By instance_name Then run it again at the end of the day. Subtract one set of values from the other. That will give you the most ...


Unless you have Systems Centre Operations Manager with the SQL Server Management Pack, a good way is to set up some sort of data collector that queries the appropriate DMV's. Assuming you are running SQL Server 2008 + you can set up a Management Data Warehouse on the instance using SQL Server Management Studio. The result is a graphical user interface in ...


run given command.this will kill all process associated with oracle. like smon , pmon,dbwriter process. kill -9 ps -e | grep ora_* | awk '{print $1} ### and start again with . oraenv & sqlplus / as sysdba


You might want to look at the following links: Seems like you need to upgrade to 5.6 prior to replicating to 5.7 from 5.5. Too bad, the documentation is so cryptic " ...


I think sp_Blitz by good folks at Brent Ozar Unlimited is the best way to go with a new to me server.


The simple ans is No, it will not Effect until you have specified your user account in Oracle Service you can change the password by insuring it is not assigned to Local System


Oracle on Windows creates a service for database instances, called OracleService%ORACLE_SID%. By default, this service uses the Local System account so a password change of the installation user will not affect the database. It is however possible and recommended to change the service user from Local System to a standard Windows account. If you performed ...

Top 50 recent answers are included