I want to know whts going wrong with it, its looking somehow challenging. I know if I will restart services it will clear the issue. but I want to konw...

Yeah..!! 🙂 I did it.

I was trying to create user with "Windows authentication" as it was local user, I was getting error. I tried with "SQL Server Authentiacation" and it...

Thanks Hanshi for the information..!

I did not knew that in 2000, SQL Services named as "MSSQL...", I caught it and its working fine. Morover, I checked the event logs and...

I got an alert "Total_Locks>=4000 " !!

I dont know how much it should be.

I tried sp_lock and can see around 3853 rows. But dont know whether that is the...

Gila Monster, Can you please answer my questions ?

========================================

Hello Guys,

I analysed one thing, the machine which is facing low cache hit ratio issue is in cluster and its currently in...

Sorry Gila I did not read edited data.

My current SP is SP3 on MSSQL Server 2005, My one of collegue told me that upgrading SP3 to SP4 Or upgrading 32bit...

Thanks Gila for the quick response!

I use sp_who2 to find out current running processes. I can lots of process running, how can i identify that specific apps those wants more...

Hello Rohit,

What is the size of your disk on which you are taking backup, what is size of your total databases whom you want to backup ?

Let me know above...

thanks a lot Todd, for your response,

After long troubleshooting we come to know it was storage issue. After our storage rebooted, one of our drive was not showing. We rebooted...

Hello Kevabug,

Thanks for quick reply,

Is it possible to add serial key after installation ? or we need to reinstall sql to just enter product key ?

Gail...!! Kudos...!! Its working perfect now... Clients are very happy. Thnx a lot for your guidance again.:-)

Thanks Gail for the explanation!

I went to properties and set the Max memory to 14GB(Total RAM 16GB) which was before by default. And

now its in normal online mode, and...

Thanks a lot Gail...!!!

I completed all the activity with no error and this time took full backuk before doing anything.:-D. I handed over the system to check if there is...

Hello Gail,

I think there is no index on PTPortal db..!!

I ran

SELECT 'dbcc dbreindex(''PTPortal.DBO.' +name+ ''')' FROM sysobjects and did not found those corrupted tables there...

Just can...

Yesterday I tried to run checkdb with repair_rebuild option but fails due to log file full. I will try again after shrinking db log file.

@Gail: Is it possible to perform...