Viewing 15 posts - 76 through 90 (of 144 total)
Sounds like the right approach. In my office, we lose the old servers within a couple of weeks as they get re-purposed (if they are of decent specs) by the...
July 9, 2004 at 8:35 am
Shouldn't be an issue. We've done it many times here. We've either created a new server with a new name and repointed any ODBC drivers to the new server or...
July 9, 2004 at 7:48 am
Sorry, I should have said we currently have 2 GB with it dynamically set. I see a lot of hits on buffer cache and want to try and size up...
May 25, 2004 at 11:12 am
John,
On the server I'm getting a cache hit ratio of 99.3%. What else within DBCC PERFMON should I watch?
April 23, 2004 at 9:47 am
I reindex the database nightly and update statistics nightly as well. I do see buffer cache taking hits periodically throughout the day and figured the additional memory would help. Your...
April 23, 2004 at 9:26 am
Thnaks, I appreciate the responses. I'm always a little leery about applying something to production that I haven't quite proven as being an improvement.
April 22, 2004 at 12:27 pm
We are running SQL EE and advanced server. I've never seen an issue with memory in dev, where I playing around with this. I do see it as an issue...
April 22, 2004 at 12:01 pm
Steve,
Did you get anywhere with this? I've seen the same thing at my shop but everyone I talk to tells me we're configured correctly. Thanks.
April 12, 2004 at 1:19 pm
Does anybody have a handy script that will identify search fields for the _WA** indexes?
April 12, 2004 at 12:54 pm
One file per backup, so if you retain for 8 days, you'll have 8 files.
April 8, 2004 at 2:39 pm
You can also use a maintenance plan and specifiy within there "Remove files older than". If you specify 8 days, this will retain each file for 8 days and then...
April 8, 2004 at 2:10 pm
Won't this potentially lead to physical framentation with shrinks and then auto grows? Will the backup, restore and rename option be the best approach? I realize it would probably be a...
March 31, 2004 at 2:15 pm
Thanks, after I posted, I found another thread to an article by Ken Henderson which spelled that out very clearly. I appreciate the response.
March 31, 2004 at 11:15 am
How do I determine what is being allocated to SQL. We run SQL2K sp3 on Win2K sp4, non-advanced server, with 4GB ram. I want to allocate 3GB to SQL so...
March 31, 2004 at 10:27 am
Viewing 15 posts - 76 through 90 (of 144 total)