Viewing 15 posts - 2,461 through 2,475 (of 2,639 total)
Can be tricky - usually there are some install folders left and quite often registry entries - beware of any odbc/mdac registry entries as if you mess them up you...
March 11, 2005 at 8:32 am
I have production servers running with HT and am about to upgrade to to 8 way + HT ( = 16 ). I can't say I've seen any real problems. It's...
March 10, 2005 at 8:44 am
I can think of any number of reasons you may have problems.
I suggest you monitor to see if the reads are physical or logical. Technically a repeated query should...
February 9, 2005 at 10:24 am
On a small box restricting processors is rarely effective. I'd remove any restrictions on cpu and see what happens.
If cpu 1 is not doing much and cpu 0 is overworked...
February 9, 2005 at 10:10 am
the spawn of the devil, along with cursors !! < grin >
February 3, 2005 at 4:05 am
There are some requirements but I have it running on a p11 450 with 512 mb ram and although it complains it works well enough for eval. I seem to...
February 3, 2005 at 4:04 am
the db_datawriter role should come with a public health warning - hope you relasie it also allows users to update system tables ?
I believe you could set up application roles...
February 3, 2005 at 4:01 am
Yup clustered indexes rebuilt, stats updated, however it does give me one possible lead
February 2, 2005 at 5:49 am
Yes you might need to defrag system tables, I'm not sure how much impact there would be of course.
How you approach this is another matter - I'm a little wary...
February 1, 2005 at 6:37 am
You should be able to identify what is causing a block, you could run a query against sysprocesses or there are lots of procs available from microsoft technet if you...
February 1, 2005 at 6:30 am
I'd make sure you have fully refreshed EM, it's notorious for being out of date if you don't refresh manually.
If you open up properties for your server and click on...
January 31, 2005 at 6:38 am
Large error logs are only a real problem when you want to read them! Mine hit around 80Mb a day ( using deadlock trace flags which bloat the log !)
I...
January 31, 2005 at 6:32 am
Well 8Gb for a database isn't very large, maybe the number of rows has an impact. I'd make sure your tables are definite heaps if the issue is with inserts?
Timeouts...
January 31, 2005 at 6:29 am
Technically you could never stop a sysadmin. I'd probably drop the procs if I were that worried about it or remove the sysadmin users.
December 21, 2004 at 2:00 am
Viewing 15 posts - 2,461 through 2,475 (of 2,639 total)