Printable View
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
It depends which database system(s) you are using, and what you mean by "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
OK, but is it SQL Server ? Oracle ? MySQL ? Access ? etc.
SQL ServerQuote:
Originally Posted by CVMichael
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.