Search Results

Thread by: Unsure, Aug 10, 2011, 11 replies, in forum: SQL Server 2008 Reporting Services

How do I change the location of the Reporting Server log files? By default they are created on (our server) C:\Microsoft SQL Server\<SQL Server...

Thread by: Unsure, Oct 14, 2008, 10 replies, in forum: General DBA Questions

Hello, Currently have an Active/Passive Cluster. Looking at using the Passive node to setup replication for some of the databases that are on the...

Thread by: Unsure, Sep 16, 2008, 2 replies, in forum: Performance Tuning for DBAs

Hello, RAM is 32GB. Memory allocated to SQL Server is 30GB. AWE is enabled. What should the Performance Counter - 'Total Memory' for the SQL...

Thread by: Unsure, Aug 25, 2008, 4 replies, in forum: General DBA Questions

Hello, Total Physical Memory on the server is 25GB. SQL Server 'MAX MEMORY' is set to 20GB. The SQL Server has been hanging. When this happens...

Thread by: Unsure, Aug 10, 2008, 6 replies, in forum: Performance Tuning for DBAs

Procedure 'Proc_Level3' calls procedure 'Proc_Level4'. Procedure 'Proc_Level4' populates a temp table. I created an index on the temp table. My...

Thread by: Unsure, Aug 6, 2008, 7 replies, in forum: Performance Tuning for DBAs

Hello, I have been trying to fine tune a query that involves this one table. The table contains 725,027 rows. Plan 1 The original query completes...