Forum Replies Created

Viewing 15 posts - 391 through 405 (of 496 total)

  • RE: Permissions to run jobs

    It is MS SQL2000 sp3...

  • RE: Counter log export

    2amitelman: This is what I was looking for, but it only installs on sp2.

    Thanks anyway.

  • RE: Raid performance

    Hi!

    Just want to correct myself, I used a wrong counter:

    Avg. Disk Bytes/Transfer

    That is:

    quote:


    Avg. Disk Bytes/Transfer is the average number of bytes transferred...

  • RE: Counter log export

    It is Win2k Adv Server 2000 sp4 + MS SQL 2000 Ent sp3

    /* wonder how the version of MS SQL server makes difference */

  • RE: Raid performance

    I read that for hardware RAID, windows defrag will worsen performance. Unfortunately can't provide a link.

    Just another question: how to figure out the allocation unit (cluster) size of NTFS...

  • RE: Raid performance

    2EdVassie:

    quote:


    a) Any type of disk storage can be fragmented. Fragmentation is a mainly a function of the file system, not the disk....

  • RE: Raid performance

    2Allen_Cui:

    quote:


    "Could it be hardware issues?"


    -What kind of hardware problem can this be?

    The server has...

  • RE: Measuring CPU usage

    Hi!

    Thanks a lot! This one works perfect.

  • RE: Measuring CPU usage

    Hi!

    It works almost perfect. I does not handle "single row" processes. So I got all 28 rows,

    but the first three of them were not correct:

     
  • RE: Measuring CPU usage

    2ripg1011: I changed clause "order by cpu1.dt desc" to "order by cpu1.dt desc, cpu1.spid", but still get 23 instead of 28 rows for previous example. This is the query...

  • RE: Measuring CPU usage

    2ripg1011:

    It works fine for one process, so I took a few others:

     
    
    dt ...
  • RE: Application log on a cluster

    Yes, the domain account, that Cluster service uses to log on has a login with sa role...

  • RE: Rights for public role

    All the users of these databases are also users of the application, so, if there is no way to organize application roles for application with multiple databases, perhaps the guy...

  • RE: The results that fn_get_sql() returns.

    The development guys say that the right to create table for public is most probably "by mistake" and that they don't know what kind of functionality of the application may...

  • RE: The results that fn_get_sql() returns.

    quote:


    You need to check the database users and roles to see if any have unusual privileges.


    August 26, 2003 at 5:20 am

    #471384

Viewing 15 posts - 391 through 405 (of 496 total)