Viewing 15 posts - 1,756 through 1,770 (of 2,436 total)
If you use sp_who/sp_who2, examine the SPID column. SPIDs less than 50 are almost always SQL Server system processes. So for a true connection count for licensing you may want...
October 27, 2005 at 10:38 am
Out of 25 servers and 400+ databases I have one that fits this criteria. It's not the DBCC that fails it's the Optimizatins for me. As for SP4, I'd be...
October 27, 2005 at 10:35 am
I agree with SQLBill. Backup your databases to disk, then have Veritas pick up the files. It's actually more a efficient strategy because all of your SQL Server can backup...
October 27, 2005 at 10:20 am
On Win2K3, you should not have to reboot for the second and successive instances. On Win2K SP3/SP4, it's a 50/50 shot on the reboot. Also, I'd suggest shutting down the...
October 27, 2005 at 10:13 am
The SQL Server errorlog file. In EM select the Server, select Management, then errorlogs. If the file is really large (>100 Mb)then you mught want to use notepad.
October 27, 2005 at 10:09 am
It's not really one for the books. It's just a case of something 'different' from one server to the next. Now whether this was by design or not is another...
October 27, 2005 at 10:02 am
I know of these OS provided utilities:
Other vendor utilities such as:
My question still stands ... what are:
October 27, 2005 at 9:52 am
SMS & MOM each have thier limitations. Here's a cheap (less than $700) product we are workig with in addition to SMS and MOM - AuditWizard. It did a total...
October 26, 2005 at 2:04 pm
In addition to pinging by IP, I'd also try using the servername and the fully qualified servername. If either of these fail it may be a network DNS /WINs issue....
October 26, 2005 at 12:05 pm
Right click on the registered server in question in EM and select "Edit SQL Server Registration Properties" ... make sure that the "Show system databases and system objects" check box is...
October 26, 2005 at 11:42 am
It is undoubtedly a 'custom' SP. My guess is that it came from SWYNK (now SSUG). I remember having to perform the same maintenance many, many moons ago. Don't forget...
October 26, 2005 at 11:34 am
Beware of failures and slow backup times. Since you are using a NAS instead of a SAN these may be bigger issues than you think. You may want to monitor the...
October 26, 2005 at 11:31 am
I agree with Joe, "do your performance homework first !!!". We are an HP (Compaq) shop. I've got 25+ DL380's and DL580's. These machines are not 'wimpy'. Since it's a...
October 26, 2005 at 11:28 am
Where was the output supposed to go ? Wher is the output currently going ? What changed since Friday ???
October 26, 2005 at 10:39 am
Also, when viewing the results online I've found that switching your font to courier 10 will fix quite a bit of your column alignment issues.
October 26, 2005 at 10:37 am
Viewing 15 posts - 1,756 through 1,770 (of 2,436 total)