Viewing 15 posts - 361 through 375 (of 408 total)
Did you get a SQL Trace at the same time? CPU usage, etc. are directly related to queries, etc.
Joe
October 27, 2005 at 2:28 pm
Been there done that, had some folks who came up with a wonderful code lookup table that encompassed every possible code known to man from state abbreviations down to job...
October 26, 2005 at 10:23 pm
Making 10-15 changes per day to a production server is not sustainable, sooner or later it's going to bite you in the butt.
A change management/ QA / release process...
October 26, 2005 at 9:59 pm
Uh oh, am I going to have to change my name again? Somebody stole my Galactic Overlord identity and after much gnashing of teeth they finally let me change my...
October 26, 2005 at 9:28 pm
JoeTeck -
Choose "SQL server 2000 components" - depending on your version of windows you may or may not be able to install a local version of the actual database server,...
October 26, 2005 at 7:09 pm
Good point, I've seen other folks post print screens of their query plans here - but never tried to do it myself - anybody?
Joe
October 26, 2005 at 11:58 am
If you could get us the query plans for both servers, that would probably help.
One thing you may need to look at is other activity on the production server...
October 26, 2005 at 11:49 am
Your login failed for "user '(null)'" is due to the configuration of your IIS server - when using integrated security from a web server you need to use a domain...
October 25, 2005 at 11:37 pm
I would recommend using the instructions at http://www.sql-server-performance.com/articles_audit.asp to get a good idea of what is really going on with your database server before changing anything or setting your course. Nothing...
October 25, 2005 at 11:15 pm
Can you provide the query? Even better include screen shots of the query plans from both servers.
Might help...
Joe
October 25, 2005 at 10:59 pm
Checking for email arrival via xp_readmail is definitely an option, a scheduled job that checks every 5 minutes or so for the email to have arrived would work just fine...
October 25, 2005 at 10:10 am
If you aren't too far down the road of rolling your own, I've used a product called ServersAlive to good effect to monitor a pretty wide variety of servers, SQL...
October 21, 2005 at 1:36 am
Did you restart SQL Server after installing and configuring the certificate?
Joe
October 21, 2005 at 1:17 am
Derek -
Unfortunately there's no way that I'm aware of to hide databases from authenticated SQL Server 2000 users - everyone with EM will see all of the databases, they...
October 20, 2005 at 6:17 pm
Viewing 15 posts - 361 through 375 (of 408 total)