Search Results | SQL Server Performance Forums

Creating a Non-Cluster Index

Thread by: Ksr39, Oct 23, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, I need a small help in creating non cluster index on a table as we were facing a performance issue. The issue was in one of our...

Deleting the tables which are not been used from long time.

Thread by: Ksr39, Oct 10, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS

HI Experts, Actually we are planning to replicate the prod data to our DR center. So, thinking to replicate only that data which are used, so I need...

CPU Allocation In SSMA

Thread by: Ksr39, Oct 3, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, Need small information on CUP allocation in SQL Server 2005 64bit Enterprise edition on windows 2003 64bit Enterprise edition. What is...

SQL Server using max memory

Thread by: Ksr39, Sep 21, 2012, 25 replies, in forum: ALL SQL SERVER QUESTIONS

HI Experts, I have a small concern again on SQL Server Memory issue as one of my prod server runs on SQL Server 2005 Enterprise edition 64 Bit, on...

LogShipping Failed

Thread by: Ksr39, Sep 17, 2012, 5 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, In one of my prod server I have configured logshipping for two databases in a single server (SQL Server 2005 Standard edition 32bit on...

Database backup taking much time

Thread by: Ksr39, Sep 6, 2012, 5 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, Today one of my database took more than expected time for backup i have no idea why it took much time, can any one help me in this if any...

preparing for 70-432 exam

Thread by: Ksr39, Sep 5, 2012, 4 replies, in forum: ALL SQL SERVER QUESTIONS

Hi All, If any one of you has any dumps or any test papers for the 70-432 exam, Please forward so that it can be help full to us those who are...

Maintenance plan

Thread by: Ksr39, Aug 16, 2012, 4 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, On one of my Pre-Prod server I have created a maintenance plan and in that there are full and a log backup scheduled and retention is...

Full backup will have the latest T log backup

Thread by: Ksr39, Aug 14, 2012, 3 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, I have a doubt about full and T log backup, Today when I was working on one of my prod server I found that one of my database backup is...

SQL Server Configuration Manager Error

Thread by: Ksr39, Aug 7, 2012, 8 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, I got an error while I was trying to connect to the SQL Server Configuration Manager, The server is in cluster and it’s in Single node...

Health Check for SQL Server 2005

Thread by: Ksr39, Aug 6, 2012, 7 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, Need a small help as I want to do health check on my sql server 2005, I was wondering is there any script so that I can run and check...

Data Flow

Thread by: Ksr39, Aug 2, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS

Hi Experts, I just wanted to know how much I/O is done on a particular database per day. How can I find this on a single database? Please help me on...