Can you recommend a program, or other means, to generate lots of DB test data (e.g. 10GB) for perfo…
18 years, 2 months ago
I have been monitoring the procedure cache on my SQL 2000 DB. It is an Ecommerce DB. The procedure …
By: Rob DeMotsis
Hello all. (I'm not sure that my message is convinient for this forum, but i don't know where else …
By: David Benoit
How do I clear the procedure cache?
dbcc freeproccache (undocumented) - Removes all elements from t…
By: Steve Jones - SSC Editor
Have just started doing some performance monitoring using the profiler tool. Each time a sp is call…
My processors on one server are avg 85+ utilization. I am in the process of trouble shooting this t…
I'm trying to find any information about SQLSERVER 6.5 running on an Octoprocessor.
It seems that t…
We are on SS2K. In errorlog we are gettinig
"This SQL Server has been optimized for 8 concurrent qu…
Has anyone used pintable before? what was
Just finished working out a problem (well, probably not a problem as such) with views.
By: Andy Warren
Ive spent some time buggering around with profiler under ss2k EE. Basically
I only want to …
18 years, 3 months ago
Prior to version 7 you could specify that tempdb resides in ram. This feature has been taken away …
I'm trying to keep a full text catalog constantly updated using change_tracking, and background_upd…
Don't know if I am missing something. I have just returned from a training class on optimizing SQL…
Simply put, what are the benefits of doing one over the other.
I favor updating statistics, but I h…
By: Tom Goltl
Viewing 15 topics - 2,551 through 2,565 (of 2,580 total)
You must be logged in to create new topics.