Professional Web Applications Themes

Trace flag 1024 - Microsoft SQL / MS SQL Server

What risks are there in running the 1204 trace flag on a production server? Thanks Bob Castleman SuccessWare Software...

Sponsored Links
  1. #1

    Default Trace flag 1024

    What risks are there in running the 1204 trace flag on a production server?

    Thanks

    Bob Castleman
    SuccessWare Software


    Sponsored Links
    Bob Castleman Guest

  2. #2

    Default Re: Trace flag 1024

    Very few, unless you are on SQL Server 6.5.

    If you have a lot of deadlocks, of course, it will put a lot of messages in
    the log. But that is what you want until you figure out what is going on.

    Russell Fields
    "Bob Castleman" <nomailhere> wrote in message
    news:uqbB8D9PDHA.1072TK2MSFTNGP10.phx.gbl...
    > What risks are there in running the 1204 trace flag on a production
    server?
    >
    > Thanks
    >
    > Bob Castleman
    > SuccessWare Software
    >
    >

    Russell Fields Guest

Similar Threads

  1. 1024 or 800 pixels?
    By Tom Thackrey in forum PHP Development
    Replies: 6
    Last Post: November 15th, 09:23 PM
  2. Flag wave
    By Gianpiero Colagiacomo in forum Macromedia Director 3D
    Replies: 7
    Last Post: September 29th, 11:55 AM
  3. Binding server to port < 1024
    By Mark J. Reed in forum Ruby
    Replies: 3
    Last Post: September 2nd, 10:41 AM
  4. Solution: Closing Port 1024 (wdm or xdm)
    By Jesse Meyer in forum Debian
    Replies: 0
    Last Post: July 19th, 06:40 AM
  5. Florida Flag==
    By David in forum Photography
    Replies: 0
    Last Post: July 16th, 11:23 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139