Hi, Now this post we see that how can we get some basic information of SQL Server using SQL Stored Procedure. Some different SP are given below as an example.
If there is any other better option,
|
System Stored Procedure
|
Reports Information on
|
|
sp_who
|
Current SQL
Server users and processes
|
|
sp_lock
|
Active
locks, as well as blocking and deadlock information
|
|
sp_spaceused
|
The
amount of disk space that a table or a database uses
|
|
sp_helpdb
|
Databases
and their objects
|
|
sp_monitor
|
SQL Server
statistics, such as total processing time, number of reads and writes, and
connections
|
|
sp_helpindex
|
Indexes on
a table
|
|
sp_statistics
|
All indexes
on a specific table
|
If there is any other better option,
Thank You,
Arka Gupta.
No comments:
Post a Comment