Viewing 15 posts - 37,966 through 37,980 (of 39,720 total)
Thanks, I'm was trying to present some information on a topic that may have stumped some people. I plan on continuing with other items as I find them and I'll...
March 25, 2002 at 9:25 am
Great advice from Andy. One note, if you use a maintenance plan, DO NOT repair problems. It causes issues.
Steve Jones
March 24, 2002 at 4:29 pm
There is also an event that fires (1864?) and you can capture this as an alert.
Steve Jones
March 24, 2002 at 4:27 pm
Tend to agree that you should fix the queries if you have time, or at least test if you can. If it's a critical production box, I'd leave it off...
March 24, 2002 at 4:01 pm
March 21, 2002 at 4:39 pm
Might be some type of issue with the user executing packages. Can they execute some other simple package?
Is this a copy db task?
Steve Jones
March 21, 2002 at 2:15 pm
If you choose a directory, then you do not need an IP. It will do a file copy.
you can schedule the pacakge. Right click the package and choose "Schedule"
Steve Jones
March 21, 2002 at 2:12 pm
It's a security issue in that SQL doesn't "lock" accounts, so someone can constantly be connecting to that server and trying passwords. sa is a well known account. You can...
March 21, 2002 at 2:06 pm
Didn't know that. Is this an instantaneous value? Updated every xx sec/ms?
Steve Jones
March 21, 2002 at 2:03 pm
I'll try to look around, but AFAIK SQL doesn't maintain these types of statistics. Profiler, Performance Montitor were designed to do this.
Steve Jones
March 21, 2002 at 1:44 pm
Shouldn't be an issue. SQL is usually designed further ahead than Windows for scale. Supposedly SQL 2000 is 64bit ready. Just waiting for Windows.
Steve Jones
March 21, 2002 at 1:41 pm
At TechEd 2000, I heard a presentation about Microsoft.com. They talked about designing a stateless system because the use of "session" variables inhinbits your scalability. Each user is then "bound"...
March 21, 2002 at 1:32 pm
March 21, 2002 at 1:29 pm
March 21, 2002 at 1:25 pm
Personally, I'd let the instances compete and then see what happens. SQL does a good job of managing itself, though I'm not sure how the instances will work with each...
March 21, 2002 at 1:19 pm
Viewing 15 posts - 37,966 through 37,980 (of 39,720 total)