thanks everyone for the reply...i still couldnt find the right answer..all the features mentioned above like data compression and DW features are also present in sql server 2008...i am trying...

thanks everyone ...i know i cant have two dbs with same name under same instance...i was looking is there a way setup some alias..or something else..

thanks Gila. Got it. I am trouble shooting on a performance issue where there are many tables with out any indexes on it, do you think creating a cluster index...

thanks everyone..yes the job was enabled...there are other jobs on the same instance and they ran fine with no issues..only just this one..

well i do not see the memory issue after making changes but i still see the page file size shows like 21 gb out of 34 gb from task manager...

thanks Jeff..Yup i realized the memory in in Mb.s

thanks everyone for the reply. I have two instances running on it and i have set 2 and 16 gb min/max for one and 2 and 8 gb min/max for...

thanks Jeff. Yes i did assign more memory to OS ..before it was only 4 gb now around 8 gb and ram is 64 gb..So far things looks good.

i did try splitting the tempdb files and putting on a san disk..dat didnt help..only the firsttime after recycle it works..other times takes longer..cld this be a 64 bit issue

thanks..ok i will assign 10 gb to log file and 2gb max size to each data file..now do u want me to split the data files on differenct drives or...

when i look in the properities under the sql server instance i see 16 processors..space is not an issue..i have couple of drives...if you want i can keep atleast...

thanks for your reply....server has 16 processors with 32 gb of RAM and has two instances on it. But the second instance has very limited activity on it for the...

some updates on this one..procedure runs fast after recycling the sql services...and everytime after that exec time increases....is this issue with tempdb? i am planning to move tempdb to SAN...

thanks..will update you if i find a solution for it

thanks everyone for response. I will not be able to get the execution plan since it had arnd 30 execution plans for one proc, like the proc has batches of...