-
Mar 24th, 2011, 08:49 AM
#1
Thread Starter
Lively Member
checking database which get server troubles
Hi everybody
I was discussing that pint with my friends.
If I am database administrator and get troubles in my server from some of databases.
What can I do to monitor or observe that databases to find out which database get my server troubles?
bintaleb
-
Mar 24th, 2011, 08:53 AM
#2
Re: checking database which get server troubles
It depends which database system(s) you are using, and what you mean by "troubles".
-
Mar 24th, 2011, 02:35 PM
#3
Thread Starter
Lively Member
Re: checking database which get server troubles
Hello,
thank you so much for help I am still learning
I am talking about user defined database which is given by developers.
regarding "troubles" I mean for example: to make server slow or so on
bintaleb
-
Mar 24th, 2011, 02:39 PM
#4
Re: checking database which get server troubles
OK, but is it SQL Server ? Oracle ? MySQL ? Access ? etc.
-
Mar 24th, 2011, 02:44 PM
#5
Thread Starter
Lively Member
Re: checking database which get server troubles
Originally Posted by CVMichael
OK, but is it SQL Server ? Oracle ? MySQL ? Access ? etc.
SQL Server
-
Mar 24th, 2011, 03:19 PM
#6
Re: checking database which get server troubles
Have you tried a server side trace using Profiler? Save the results to a file then analyze the results.
Is it a test or production server? If test look at SQL Nexus it will place a load on the server when running that is why I say to use it if on a test server.
Sometimes the Programmer
Sometimes the DBA
Mazz1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|