Results 1 to 5 of 5

Thread: high transaction/sec on master database

  1. #1
    Join Date
    Apr 2003
    Posts
    6

    high transaction/sec on master database

    Hi,
    I have a cluster sql server 2005 enterprise edition(SP2) and while I was checking few performance counter on the perfmon, I came across something really strange.

    Monitoring transaction/sec counter for the total transactions, master and production database shows that the when the CPU usage is high, the transactions/sec on master database can be as high as 2000 while the production is just 50.
    which is quite strange.
    another thing that it might worth mentioning is that the number of active transactions against master is 0 while on the production database the active transaction is 10-15
    any ideas?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Certain processes involve master db, like login to sql. You can trace them in profiler to get better view.

  3. #3
    Join Date
    Mar 2007
    Posts
    27
    Thanks,
    but when I profile server for the transactions. all the transactins I can see it's againt the production database and nothing against master.
    apart of login/logouts what other transactions are getting processes against master database?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Every time you click on something in ssms, it may call system sp in master.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    If you have any security audit running then it will connect to master database multiple times. check for all auditing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •