Viewing 15 posts - 16 through 30 (of 106 total)
Yes simply adding more RAM to the machine may help but that depends on your current settings and how much you do have and if the max server memory is...
August 15, 2007 at 8:34 am
A while back I did a word doc for a meeting that I had with a bunch of fellow DBA's. You can see it here in my blog titled
How to...
August 6, 2007 at 11:14 pm
I have 1Gb for my server and it still thrashes a bit at peak periods. Since you have 16GB, you might want to go higher for the OS.
Shawn
August 1, 2007 at 4:41 pm
Vik
It is ignored on 64 bit OS/SQL. You can set it but it is ignored. Doesn't matter which version -- standard or enterprise.
Also, don't let SQL dynamically manage your RAM...
August 1, 2007 at 12:31 pm
We too had a similar issue and couldn't figure out what was happening. The base install of SQL 2005 sets SQL to manage all of the memory something like Max Memory...
August 1, 2007 at 7:39 am
One more thing that I forgot to post. Since you rebuilt this server and I am assuming restored your databases, it would be wise to make sure to reindex and...
July 23, 2007 at 4:50 am
We had a similar issue and in short what was happening was that virtual memory was killing the server and eventually not allowing memory to be allocated and the server...
July 23, 2007 at 4:40 am
We recently moved our datacenter and went through this whole discussion. The Finance/Sr Mgmt/Auditors all pulled that same argument that I couldn't have the SA password nor be a local...
June 25, 2007 at 7:23 am
Several years ago we had a lengthy discussion here about Double-Take...good and bad so make sure to read through it as there are some data integrity issues.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=317781
We used...
June 25, 2007 at 6:59 am
Sorry, got to reading the other pages....
We had an IBM server do the same thing. We had the beginnings of a logical hard drive failure in our Raid 5 array. ...
May 30, 2007 at 9:45 pm
Take a look at your MSDB database . All the backup job logging is stored in four tables (backup*). If these get too large, I have seen a dramatic decrease in performance. ...
May 30, 2007 at 9:39 pm
My route to DBA was a varied one and I have never had an official programming or DB class. I had always planned on a business career (accounting/finance/international trade) but programming...
May 3, 2007 at 10:07 pm
Unfortunately, I get to be the snooper at my company. I have written a couple of small apps that I have developed over the years that help me. Basically, I start...
May 2, 2007 at 10:18 pm
Steve,
I am doing just that on my blog http://blog.mathomsolutions.com/ The first post was about our current system and the goals we want to achieve and why. I am about ready...
April 24, 2007 at 7:38 am
HGhumphrey,
could you send me a private message (just click on my name to the left and that will bring up my profile and there should be a link to send...
April 17, 2007 at 11:49 am
Viewing 15 posts - 16 through 30 (of 106 total)