The expected counter value is in percentage format.

If you want the alert to fire when CPU usage exceeding 90%, set it to 0.90

Both or our SQL 2005 and 2008 Enterprise Edition are 64bit.

The one difference is SQL 2005 runs on Windows Server 2003,

and SQL 2008 runs on Windows Server 2008.

Hi, tempdb is at 500MB with over 100MB free consistently test after test, so it doesn't appear to me that tempdb was starving.

And I did rebuild the indexes completely, after...

We are migrating our SQL 2005 cluster to the new 2008 cluster which is running on brand new hardware, HP ProLiant DL980 G7, database devices are on EMC Enterprise SANS...

Hi,

The 2008 server has 4 Xeon X7560@2.26GHz /16 cores.

Statistics were updated.

I did not check index fragmentation previously.

So I went ahead and rebuild the complete indexes.

Tested with both MAXDOP=1 and MAXDOP=0....

Is this the "Login Auditing" feature that can be enabled from the Server Properties in the Management Studio that you're referring to? Or is this a different method, if so,...

I am not sure if this is what you need, but when running interactive BCP, by NOT specifying any of the format arguments (-f, -c, -n, -w, -N, -V) BCP...

Here are some related posts on this error message.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=272688

http://www.mcse.ms/archive95-2005-6-1699799.html

http://www.dbtalk.net/microsoft-public-sqlserver-replication/merge-agent-status-process-running-226319.html

Can someone please explain the posted sp above (for the case of targeting a remote server), how could the the Total disk size coming from the remote server disks and not...

Hi Brian,

I guess the answer to your question is it depends.

With my limited testing in our environment, I've found this issue only affects NT login via group membership.

For example:

1) If...

F.Y.I.

I did get a confirmation from Microsoft that this is a bug generated by SP4.

This problem is contributed by the data type inconsistency in the system tables. SID column in...

By any chance, have you check to make sure the Distributed Transaction Coordinator is started on the second remote server ?

With SQL Profiler, you can set up traces to capture information of your interest.

You can select based on event classes.

(i.e. Stored procedures, TSQL, Objects event classes .etc. provide information...

It is most likely that the link between database users and server logins are broken.

For a start, you want to login as an 'sa' and examine the login information (sp_helpuser...

If I understood your question correctly.

You have a stored procedure that expects an integer input argument.

The user executes this stored procedure and passes in a varchar value instead, and you...