There are basically two types of indexes that we use with the SQL Server. Clustered and the Non-Clustered.
Search This Blog
Database : What is a trigger?
Triggers are basically used to implement business rules. Triggers is also similar to stored procedures. The difference is that it can be activated when data is added or edited or deleted from a table in a database.
Can you give an example of system defined Stored Procedure?
sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.
Database : What is a Stored Procedure?
Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.
Database Performance Monitor (ST04)
Database Performance Monitor (ST04) provides a database-independent tool to analyze
and tune the following components:
< Memory and buffer usage
< Space usage
< CPU usage
< SQL requests
< Detailed SQL items
1. In the Command field, enter transaction ST04 and choose Enter (or from the SAP standard menu, choose Tools ® Administration ® Monitor ® Performance ® Database ®
ST04 - Activity).
2. An initial overview of database activity is provided which pertains to database,operating system, CPU, and memory.Microsoft SQL Server allows the analysis of specific attributes pertaining to memory, space, I/O, and quality of table reads and writes. This information can signal adjustments necessary to improve performance of the database.
a. Memory Usage Procedure cache and Data cache hit ratio can reflect memory problems.These values should be greater than95 percent for optimal memory usage.
b. Server Engine/Elapsed Shows how hard the CPU has beenworking on Microsoft SQL Serverprocesses. You are interested in theratio of busy : idle time.
c. SQL Requests Allows for snapshots of how SQL queries are utilizing table access pertaining to full table or index scans.A high ratio of full table scans vs. index scans can indicate performance bottlenecks.
d. Detail analysis menu
and tune the following components:
< Memory and buffer usage
< Space usage
< CPU usage
< SQL requests
< Detailed SQL items
1. In the Command field, enter transaction ST04 and choose Enter (or from the SAP standard menu, choose Tools ® Administration ® Monitor ® Performance ® Database ®
ST04 - Activity).
2. An initial overview of database activity is provided which pertains to database,operating system, CPU, and memory.Microsoft SQL Server allows the analysis of specific attributes pertaining to memory, space, I/O, and quality of table reads and writes. This information can signal adjustments necessary to improve performance of the database.
a. Memory Usage Procedure cache and Data cache hit ratio can reflect memory problems.These values should be greater than95 percent for optimal memory usage.
b. Server Engine/Elapsed Shows how hard the CPU has beenworking on Microsoft SQL Serverprocesses. You are interested in theratio of busy : idle time.
c. SQL Requests Allows for snapshots of how SQL queries are utilizing table access pertaining to full table or index scans.A high ratio of full table scans vs. index scans can indicate performance bottlenecks.
d. Detail analysis menu
Subscribe to:
Posts (Atom)