Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

monitor SQL2008

Posted on 2010-01-03
1
Medium Priority
?
182 Views
Last Modified: 2012-05-08
hi,
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_25013175.html

EE suggested me to open a new question becasue I am not using enterprise edition, I want to see if there are any other options...thx
0
Comment
Question by:mcrmg
1 Comment
 
LVL 13

Accepted Solution

by:
MikeWalsh earned 500 total points
ID: 26168102
If you can minimize the activity to the user you suspect, I would consider a server side trace to a file and see how it goes. Watch the server for performance and for the file growth and filter out any known negative causes.

You could also try and restrict access and see if the problem goes away.

There are tools out there like Sentrigo's Hedgehog that have less impact and don't require enterprise edition: http://www.sentrigo.com/
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question