Multiple instances of SQL

According to the Task Manager, on my SBS 2003 Server, I'm running multiple instances of SQL. How do I determine which instance(s) are required to maintain server stability, and which are not. My Server resource use continues to be a perennial problem. Please advise.

Hi,

perhaps this article at Database Journal help Monitoring SQL Servers Availabilty.

|||

You most likely have the following instances, for the stated purposes.

MSSQL$SHAREPOINT -necessary if you are using Sharepoint Services
MSSQL$SBSMONITORING - necessary for internal usage of SBS

MSSQLSERVER - Default SQL Server that may be used by your applications.

Other instances may be installed and required for various third party products.

I would not stop the first two, and only stop the third IF there are no applications requiring SQL Server.

It really sounds like you need to explore more memory or CPU power for your SBS server.

Multi-Parameter (Select All) Detection in SSRS 2005?

I'd like to know if SSRS provides a way to determine if all rows are selected from a multi_valued parameter dropdown list? I thought of how I could do this programmatically, but didn't want to build something that is already in the product (if it exists that is). Thanks.

There is no built-in functionality, but here are some ideas:

* if the multi value parameter has a pre-defined (constant) list of valid values, you know how many values are available for selection. The report parameters in RS 2005 expose a new property called .Count which tells you the count of selected parameter values (e.g. =Parameters!P1.Count). Hence, you could compare the count of the selected values with the count of the total values.

* if the multi value parameter has a dataset-based valid values list, you could just use the same field in a CountDistinct aggregate function to determine how many valid values are available, e.g. =CountDistinct(Fields!A.Value) and compare it again with the Count of selected values.

-- Robert

|||Thank you Robert. I forgot about CountDistinct.