Viewing 15 posts - 16 through 30 (of 372 total)
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...
February 18, 2009 at 4:27 pm
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...
February 8, 2009 at 7:14 am
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...
February 7, 2009 at 8:50 am
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 ...
February 6, 2009 at 10:20 am
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...
February 5, 2009 at 3:27 pm
... 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.
February 5, 2009 at 12:47 pm
I think you already found the attribute. If lockoutTime is > 0 then the account has been locked out.
February 5, 2009 at 12:17 pm
kerusy (2/5/2009)
February 5, 2009 at 7:55 am
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...
February 4, 2009 at 6:28 am
What providers are being used for the linked servers?
February 2, 2009 at 5:55 pm
Are you using linked servers or OLE Automation (sp_OACreate) on that server?
February 2, 2009 at 4:44 pm
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...
February 2, 2009 at 3:31 pm
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...
February 2, 2009 at 10:14 am
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...
January 30, 2009 at 6:55 pm
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...
January 27, 2009 at 5:16 pm
Viewing 15 posts - 16 through 30 (of 372 total)