Forum Replies Created

Viewing 15 posts - 16 through 30 (of 372 total)

  • RE: SQL profiler does not have 'import performance data' option?

    leon03tian (2/18/2009)


    Which SQL Server 2005 edition has the Import Performance Data function? I am using the Develper edition, and it is grayed out.

    Try opening a saved trace file that contains...

  • RE: Server Too SLow to Run Profiler

    I did the same but it returns traceID and stops.

    How did you determine it wasn't running? Querying sys.traces will show you the status.

    [font="Courier New"]SELECT * FROM sys.traces[/font]

    How can...

  • RE: Server Too SLow to Run Profiler

    Have you tried running the trace as a server side trace rather than through profiler? That should have noticeably less impact.

    1) Start the trace from SQL Profiler and stop...

  • RE: Using ADSI to find locked out users

    Glad to hear you got it working.

    Here's another way to do it using the userAccountControl you mentioned

    SELECT [Name], [sAMAccountname],[department],[telephonenumber]

    FROM OPENQUERY( ADSI,

    'SELECT Name,sAMAccountname,department, telephonenumber

    FROM ''LDAP://OU=Users,DC=yourdomain,DC=local''

    WHERE objectCategory = ''person'' AND ...

  • RE: Using ADSI to find locked out users

    I'd have to check this but I'm almost certain that's a limitation of the OLE DB Provider for Microsoft Directory Services. It won't handle muti-valued attributes either.

    In that case your...

  • RE: Rather critical perfomance issue

    ... am seeing a lot of recompiles .. is there something that can be done with that?

    A profiler trace should help in finding the reason those recompiles are happening.

    http://support.microsoft.com/?id=308737

  • RE: Using ADSI to find locked out users

    I think you already found the attribute. If lockoutTime is > 0 then the account has been locked out.

  • RE: BACKUP OVER A NETWORK

    kerusy (2/5/2009)


    How about backing up over a wide area network? I can back up in the local network, but when it comes to the wide area network, there's a big...

  • RE: BACKUP OVER A NETWORK

    Are you using a domain or local system account to run SQL Server?

    If you're using a domain account to run SQL it's basically two steps:

    1) On the remote server create...

  • RE: Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE

    What providers are being used for the linked servers?

  • RE: Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE

    Are you using linked servers or OLE Automation (sp_OACreate) on that server?

  • RE: Logging Perfmon Counters to SQL 2005

    Jen Hutchinson (1/30/2009)


    On a related note, can anyone point me in the direction of a source for querying the perfmon database?

    Here's a partial example. Assuming that Processor counters have...

  • RE: Strange network error

    If this happens every time you run with one id, but not the other, then I'd start to suspect something like client side anti-virus/IPS doing content inspection. Could...

  • RE: Trending Algorithm

    Are you looking to find if a current value is much different from the predicted?

    Since you're using Excel the formula and R-Squared value can be displayed for the...

  • RE: SQL 2005 IO MB/sec very slow

    When you used SQLIO how large was the test data file you used? How large was the database? Maybe the SQLIO test file was small enough to fit...

Viewing 15 posts - 16 through 30 (of 372 total)