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...
Hi Shehap/Luis, Thank you for your links, i will go for 1st option.
Hi Shehap, Thank you for the query and i found some queries which are taking much CPU time now the senior manager is asking me to tune them and i am...
Hi Shehap, After running the query i got the below results Cache Store Type Total Num Of Plans Total Size In MB All Plans - Ave UseCount...
Current memory occupied by adhoc plans only used once (MB) Total cache plan size (MB) % of total cache plan occupied by adhoc plans only used once...
Hi Shehap, Thank you for the query, i have run it on the machine and got the below resluts which i couldn't understand. please help me on this......
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...
Hi Luis, Thank you for the reply i will find the long running queries and try to tune them.
Hi Luis, Please find the results for the counters which you asked me to share.. Processor Time average of 30-35% SQL Server Memory Target Server...
Hi Experts, Need small information on CUP allocation in SQL Server 2005 64bit Enterprise edition on windows 2003 64bit Enterprise edition. What is...
Hi Luis, i will let you know the resuls as soon as i get them, thanks for the support. Shehap, The link was useful and thank you for the link, I...
Hi Luis, No we are using a physical dedicated server for the database engine and I will run the profiler by using these counters which you have...
Hi Luis, whem i saw the memory used in task manager in process tab i found this please let me know what exactly the sql is utilizing image name...
Hi Hrishi, Thank you for the reply we are going with the default retention only there is no change in it. Shehap, Sorry for the late reply, I will...
please find the SP_Configure resuts as an attachment,its an .png file
Hi Luis, Please find the results for sp_configure as an attachment, and we are seeing the cpu spike occasionally to 100% and VMemory is utilized high...
Hi Luis, I have gone through the link its good to know how much memory should be allocated to the X64bit, Yeah we have set the max memory to the...
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...
Hi Shehap, Thank you for the reply, I have configured the logshipping from the first (restoring a full backup with no recovery/standby and configured...
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...
Separate names with a comma.
