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.