Thanks Satya...I go through those topic then will discuss with you. Aman DBA Chenab Ltd.
We have running ACCPAC on our 2node clustered machine. 100-130 concurrent users access the database (SQL Server 2000). Hardware configuration Users...
Its a strict rule that whether you are going to install windows clustring and after that SQL Server clustering, the account you are using must be...
I also go that problem acouple of months before. I did whatever I can do but the ultimate solution is reinstalling the SQL clustering. Aman DBA...
Thanks a lot to all guys.... Aman DBA Chenab Ltd
Hi guys... I need sql scripts for database servers performance tuning. can anyone guide me or have the following sql scripts or let me know how can...
Thanks....for all replies.
Hi... We have 2 node clustered server with SQL2000 (SP3). Hardware config's are as under: *Dual Xeon Processor with 1GB RAM *SAN with RAID5i *100+...
You can get rid of this log file if u do not want to keep it further. Detach Database...delete the log.ldf file from Data folder. when you attach...
Dear All I have some performance related problems in our clustered base server. Hardware configuration is Dual 1.4GHz Xeon processor wth 1GB RAM. I...
Hi all... I'm also installed Antivirus on my couple of SQL Servers. But their performance is good enough yet. However would anyone like to tell...
Here is a 14 days evaluation key by which you can explore your own DBs. "xxxxx" [Deleted by Moderator] It will work with Ver 3.00. Aman DBA Chenab...
Thanks for response. Problem been solved.
Hi all... we have saveral production servers and one development server. Development server have saveral databases.But one of the DB has bulky ".ldf"...
Log_Explorer by Lumigent Technologies is the best tool to explore transaction logs. You can download its free demo form www.lumigent.com. Aman DBA...
hi maldon if paging/sec is remains more than 50% then you must increase the memory. I have also same situation as you have but paging/sec remains...
Hi.. Don't worry about that you are a beginner. "TeachYourself SQL Server 2000 in 21 Days by TechMedia" is the good book for beginners as well as...
hi.. I also agree with chapy... you need Enterprise Edition.....(if affordable) Caz I had been using personal edition and had the same problem.......
hi..licy you r on the right way.... Re-index your data. It'll most probably solve your problem. Aman
Hi Argyle Thanks for reply. It works well and I got what I want. Aman
Separate names with a comma.
