Thanks for your reply. isnull() is much bette than my case statement. Should have used that in the first place : ) (The developer used integer rather...

Got a similar question here. In my organization, we run sql server database engine and sql server analysis services in different boxes. How do I use sql server agent...

Ahmed Bouzamondo (6/25/2008)

---

Hi,

Try to use the following queries

select * from sysperfinfo --SQL Server 2000-2005

or

select * from sys.dm_os_performance_counters -- SQL Server 2005

Check the following link http://msdn.microsoft.com/en-us/library/ms187743.aspx

If the installation instance of your...

Mani Singh (6/25/2008)

---

Do you see any performance issue on the Box with counters at 0.

did the admin did a HOT INSTALL for the memory(ONLINE), or did he Shutdown the box...

Yeah, basically everything supplied by sql server. Other OS counters are fine such as Memory:Available MBytes, Processor:%Processor time.

For SQL, 0 is what I get fro the values:

Buffer cache hit...

Features:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Pricing

http://www.microsoft.com/sql/howtobuy/editionspricing.mspx

Try use sys.databases instead of sys.sysdatabases. sys.databases gives you so much more information.

check the state and statedesc columns in sys.databases.

However, this will not help you with figuring out...

Could you please provide more information on how to analyse the data? Especially DBCC sqlperf(umsstats) itself?

Also when I run

dbcc sqlperf(umsstats) with tableresults, no_infomsgs

I got the following:

One or more...

Would create a server level DDL Trigger be an option?

DDL_SERVER_LEVEL_EVENTS

http://msdn.microsoft.com/en-us/library/ms186582.aspx

I've created a server level trigger to catch people adding Logins. I catch it and then send myself/group...

If I'm understanding you correctly, you are asking if you could install a sql server instance called serverB on a physical server called serverA. However, when you make a...

Thanks for the recommendation.

Batches/Sec number is much higher than Transactions.

I just downoaded your ebooks by the way. Awesome work!

We have similar set ups on site. Jeffery is right, clustered or not, the backup configuration is the same.:cool:

Checkout the dynamic management views such as select * from sys.dm_os_performance_counters

http://msdn.microsoft.com/en-us/library/ms176083.aspx

so far, I have not found Availabele MB in any of the views.

if you are using powershell, you could write a script to check available memory(MB) metric (system.diagnostics.performancecounters()). If it is greater than a threshold, send you and your team an...

1. Make sure you are on sp2. I see no reason not to upgrade at this point.

2. For the file extension, use "bak" instead of ".bak". I've run...