Forum Replies Created

Viewing 15 posts - 1 through 15 (of 20 total)

  • RE: Missing Perfmon Counters (32-bit SQL running on WoW)

    OK I managed to sort it out:

    Perform the following steps on the site server that you want to monitor performance data:

    =========================================================================================

    Modify the ImagePath value, in the following registry key, from

    From:

    "%SystemRoot%\System32\svchost.exe...

    June 21, 2009 at 6:49 pm

    #1013108

  • RE: Memory Settings Greyed Out

    Well 1382 was what was in both boxes, but the server has 4GB of RAM. Wanted to configure it to use 2GB (I am not actually the person setting up...

    April 6, 2008 at 10:40 pm

    #798933

  • RE: Memory Settings Greyed Out

    It's SQL 2005 Ent Edition (64-bit), SP 2.

    I am logged in using Windows Auth, my account is set to sysadmin.

    April 6, 2008 at 8:32 pm

    #798905

  • RE: Tracking Illicit Users

    I pretty much use an identical script to stop developers accessing the live server.

    Unfortunately I can't disable their logins (as much as I would like to :P) as they...

    January 14, 2008 at 10:19 pm

    #767974

  • RE: Point in time restore issue - urgent

    You say you are the only one using the database - I am assuming you mean the database itself not the server.

    Even if you sp_who2 shows up with a connection...

    July 25, 2007 at 12:44 am

    #722156

  • RE: Database Size after ''''archiving''''

    As I said, I was only looking at the DATA file; not the log file size.

    Anyway, I ran DBCC (via maintainance plan) on my database and it reduced the "space used"...

    June 11, 2007 at 5:13 pm

    #712141

  • RE: Is it working sitting the 72-228 exam.

    Also, if you get your MCDBA, you can just do an upgrade exam for the MCITP.
     
    Plus having all the fancy letters after your name can't hurt

    February 1, 2007 at 9:08 pm

    #687308

  • RE: Restoring log - MB/sec

    Ahh ok so it doesn't really represent how fast it goes across the network...
     
    Thanks

    February 22, 2006 at 5:30 pm

    #622791

  • RE: User SPs on a linked server

    OK after some further testing, it looks like when I call
     
    EXEC [ServerB].[SomeDB].[dbo].[ProcName]
     
    it doesn't try to run the procedure on ServerB, it looks for the procedure on itself (ie on ServerA!!!)
     
     
    Any...

    February 21, 2006 at 8:47 pm

    #622505

  • RE: User SPs on a linked server

    Yep
     
    I have tried to call various SPs in different databases but get the same error regardless :/

    February 21, 2006 at 2:43 pm

    #622462

  • RE: Linked servers and Network Logins

    I have set for this "Be made using the login's current security context".
     
    I have also set under the Local Login section with my domain username and ticked 'Impersonate'.
     
    But I still...

    February 16, 2006 at 3:12 pm

    #621501

  • RE: Log shipping - file transfer

    Well it is several databases, I currently backup the logs which is about 1.5Gb in total - but that's every hour.
     
    You could be correct though, the size of logs will...

    February 12, 2006 at 3:42 pm

    #620342

  • RE: Log shipping - file transfer

    I know I need to take this into account, but if it was going to take longer than 15 minutes just to copy the logs over then I obviously won't...

    February 12, 2006 at 3:25 pm

    #620340

  • RE: Log shipping - file transfer

    Ahh ok... Geez all these confusing bits and bytes
     
    Well I will double check it all but at least now I have the formula to...

    February 9, 2006 at 8:42 pm

    #620003

  • RE: Log shipping - file transfer

    OK I think I meant to have 4Mb and 1.5Gb..
     
    So would these calculations be more accurate
     
    1.56Gb = 1536Mb
     
    1536/(15*60) = 1.7Mb/S
     
    1.7 * 1.2 = 2.04
     
    So theoretically I would need at least a 2Mb...

    February 9, 2006 at 3:31 pm

    #619958

Viewing 15 posts - 1 through 15 (of 20 total)