Results 1 to 6 of 6

Thread: checking database which get server troubles

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Posts
    97

    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

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: checking database which get server troubles

    It depends which database system(s) you are using, and what you mean by "troubles".

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Posts
    97

    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

  4. #4
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,802

    Re: checking database which get server troubles

    OK, but is it SQL Server ? Oracle ? MySQL ? Access ? etc.

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Posts
    97

    Re: checking database which get server troubles

    Quote Originally Posted by CVMichael View Post
    OK, but is it SQL Server ? Oracle ? MySQL ? Access ? etc.
    SQL Server

  6. #6
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,495

    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
  •  



Click Here to Expand Forum to Full Width