Users accessing SQL Server 2008 database

15 pts.
Tags:
SQL Server
SQL Server 2008
SQL Server User Accounts
how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

Software/Hardware used:
sql server 2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll want to use Activity Monitor (within SQL) to view the current performance of your database.

Use Activity Monitor to obtain information about SQL Server processes and how these processes affect the current instance of SQL Server.

The Activity Monitor page has the following sections:

Overview – Shows graphical displays of the percent of processor time, number of waiting tasks, database I/O (megabytes per second), and batch requests (number per second).

Active User Tasks – Shows information for active user connections to SQL Server Database Engine.

Resource Waits – Shows wait state information.

Data File I/O – Shows I/O information for database data and log files.

Recent Expensive Queries – Shows information about the most expensive queries.

To view the Activity Monitor in SQL Server 2005 and SQL Server 2008, a user must have VIEW SERVER STATE permission.

To view the Activity Monitor on a SQL Server 2000 server, a user must have SELECT permission to the sysprocesses and syslocks tables in the master database. Permission to view these tables is granted by default to the public database role.

To KILL a process, a user must be a member of the sysadmin or processadmin fixed server roles.

To open Activity Monitor in SQL Server Management Studio

On the SQL Server Management Studio standard toolbar, click Activity Monitor.

In the Connect to Server dialog box, select the server name and authentication mode, and then click Connect.

You can also open Activity Monitor at any time by pressing CTRL+ALT A.

To open Activity Monitor in Object Explorer

In Object Explorer, right-click the instance name, and then select Activity Monitor.

To open Activity Monitor when opening SQL Server Management Studio

On the Tools menu, click Options.

In the Options dialog box, expand Environment, and then select General.

In the At startup box, select Open Object Explorer and Activity Monitor.

To activate the changes, close and reopen SQL Server Management Studio.

Original Link: http://msdn.microsoft.com/en-us/library/ms175518.aspx

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following