Alternative of Oracle Profiler in SQL SERVER 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Alternative of Oracle Profiler in SQL SERVER 2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-12-13 : 07:38:43

Sudripta writes "Dear Sir,

In Oracle, we can create the profile by using below mentioned syntax

CREATE PROFILE

Create a user profile

Syntax:

CREATE PROFILE profile_name LIMIT limit(s) range

KEY
limit = SESSIONS_PER_USER
CPU_PER_SESSION
CPU_PER_CALL
CONNECT_TIME
IDLE_TIME
LOGICAL_READS_PER_SESSION
LOGICAL_READS_PER_CALL
COMPOSITE_LIMIT
PRIVATE_SGA

range = UNLIMITED | DEFAULT | integer

for PRIVATE_SGA specify K or M
e.g.
CREATE PROFILE MyProfile LIMIT PRIVATE_SGA 50 K

New with Oracle 8 are password related profile limits...

Syntax:

CREATE PROFILE profile_name LIMIT pw_limit(s) range

KEY
pw_limit = PASSWORD_LIFE_TIME
PASSWORD_GRACE_TIME
PASSWORD_REUSE_TIME
PASSWORD_REUSE_MAX
FAILED_LOGIN_ATTEMPS
PASSWORD_LOCK_TIME

range = UNLIMITED | DEFAULT | expression

Syntax to customise password verification:

CREATE PROFILE profile_name LIMIT PASSWORD_VERIFY_FUNCTION {plsql_function | NULL | DEFAULT}

Definitions
CONNECT_TIME - Max. time user may stay connected
IDLE_TIME - Max. time user may stay connected & idle
PRIVATE_SGA - Session space in the shared pool - K or M (bytes)
COMPOSITE_LIMIT - A weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.
PASSWORD_LIFE_TIME - Expire password after X no of days
PASSWORD_GRACE_TIME - Lock account X days after LIFE_TIME expires.
PASSWORD_REUSE_TIME - Min. no. days before the same pw may be reused
PASSWORD_REUSE_MAX - Min. no. of number of pw changes before the current password can be reused
FAILED_LOGIN_ATTEMPS - Max no. of incorrect logins before account is locked
PASSWORD_LOCK_TIME - Max. no. of days an account will be locked

Does SQL SERVER supports Profile like oracle?
If so,Would be greate if you can give me the SQL statement for creating profile.

Thanks in advance,

Regards
Rakshit.S
VisualSoft technologies
Hyderbad."

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2005-12-13 : 09:44:06

I know SQL Server 2000 does not support things like CPU quotas, and Password expiration. SQL 2005 does have password expiration, but I am not certain it has login based CPU quotas.

The short answer is no.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources