Thanks, the current PK index has 23% fragmented.again the current PK has 8 other FKs, removing this PK is bit complicated though...

Cool... Thanks for sharing your work...

MS SQL Server 2008 R2 is the latest version.

Yes you have to click "Add node to a SQL Server Failover Cluster" when you are installing SQL 2008 on Windows 2008 cluster.

Ref. the following link, it has detailed steps....

Sorry for the delayed answer.

1) Can we integrate the powershell scripts to the Policy Management or shall I say can we add this script using the GUI in policy management?

[Answer]Per...

Have you customised the " Degree of Parallelism" on SQL server side or your query resricting /limit the number of processors to use in parallel plan execution? This is also...

Per my knowledge there is no specific facet for disk volume, but I could see system policies and conditions which covers volume space and I've not explored yet. You may...

Thanks for the comments... Thought of give a different 3rd choice of answer for this question to confuse the readers but didnt realize that will mislead here... :blink:

Thanks for your comments and sorry for the confusion on the question, I took a negative meaning "great performance effect" as great performance degrade.

Thanks again for your comments...

Even I've come accross this same issue, but in my case only the LS Restore job took more time to complete and there is no issues on LS Copy job....

Thanks for your comments & is helpful to correct my writing skills brion. Also for your information, it is not been translated from any other sources, I've written this script...

If I understand correctly, this would help you...

Are you trying to restrict the CPU usage by SQL, I mean for Eg. you have 8CPUs in the SQL box by default...

Nice question... Yes.. it worked for me with Ctrl+Mouse Click.

If your backup job has a "delete old backup files" as a last step then make sure it is deleting only the old files.

Hope this would be useful for all...

http://www.sqlservercentral.com/articles/Policy-Based+Management/69587/