Troubleshooting Performance Problems › Identifying Performance Problems in CA SDM › Gather Database Server Environment Details
Gather Database Server Environment Details
Gather details about your database server. This information can help identify performance problems in CA SDM.
Follow these steps:
- Determine the location of your database server, such as local or remote.
- Determine the DBMS version, Operating System version, and patch level.
- Complete the appropriate steps for your database type:
- Execute the following queries for SQL Server and note the results:
select @@version
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel')
- Execute the following query for Oracle:
select * from v$version where banner like 'Oracle%';
- Confirm the version of the database client that you installed on the application server.
- If available, gather additional information about Environmental Data, such as the Operating System, other databases, and so on.