Search Results | SQL Server Performance Forums

Migrating SSRS from one server to two servers

Thread by: arenas87058, Feb 19, 2009, 1 replies, in forum: SQL Server 2005 Reporting Services

I'm migrating SSRS off of a sql server to a dedicated SSRS server which will connect to my sql server. 1. What are the steps? 2. There are scheduled...

Can not backup a database

Post by: arenas87058, Feb 4, 2009 in forum: SQL Server 2005 General DBA Questions

Thanks for the quick reply. I checked the log and this is what I found. It looks like a bad disk, what do you think? BackupMedium::ReportIoError:...

Can not backup a database

Thread by: arenas87058, Feb 4, 2009, 5 replies, in forum: SQL Server 2005 General DBA Questions

For some reason I can not get one database on this server to backup. Here are the specifics: 1. SQL Server 2000 SP4. 2. All other databases are being...

Fragmentation

Thread by: arenas87058, Jan 12, 2009, 1 replies, in forum: General DBA Questions

Is there a way to fragment a table for the purpose of testing what it does to performance instead of waiting for it to become fragmented? Thanks in...

Memory and CPU Resource management in a 4-node cluster

Post by: arenas87058, Nov 26, 2008 in forum: SQL Server 2005 Clustering

Ok. This sounds like SQL is doing this by itself. Can we manually set the memory configuration and reconfigure with override? I don't think so...

Memory and CPU Resource management in a 4-node cluster

Post by: arenas87058, Nov 26, 2008 in forum: SQL Server 2005 Clustering

2005. Someone made the comment that resources could be dynamically reallocated without restarting the instance if more than one instance failed over...

Building my first SQL Server 2005 2-node Cluster

Post by: arenas87058, Nov 26, 2008 in forum: SQL Server 2005 Clustering

Thanks a ton. A

Building my first SQL Server 2005 2-node Cluster

Post by: arenas87058, Nov 26, 2008 in forum: SQL Server 2005 Clustering

Thanks for the advice. But what are: 1. GPO 2. OU Thanks, A

Building my first SQL Server 2005 2-node Cluster

Thread by: arenas87058, Nov 26, 2008, 6 replies, in forum: SQL Server 2005 Clustering

Hey Guys, I'm building my first SQL 2005 64-bit cluster. I want it to be a complete success. What info do I need ahead of time? I'm specifically...

Memory and CPU Resource management in a 4-node cluster

Thread by: arenas87058, Nov 20, 2008, 6 replies, in forum: SQL Server 2005 Clustering

Hi All, I'm running a 4-node cluster. When instances fail over to a different node, can I manage how much memory and cpu each instance is allocated?...