Viewing 15 posts - 181 through 195 (of 508 total)
I can't find where you can tell windows or SQL to use a specific network path for SQL server. Also, the server doesn't know to look for the UNC shares...
July 22, 2004 at 10:07 am
Not that I'm aware of. The only issue is if a server fails over to the secondary node the counters will be for that node i.e. counters dont count both...
July 22, 2004 at 9:17 am
You can monitor SQL Server metrics through performance monitor or any tool that reads the perf counters. Can you give some detail on what you are looking for?
Wes
July 21, 2004 at 10:17 pm
If I'm not mistaken, NAS isn't supported with SQL 2000 in any way shape or form. In any case try Allen's suggestion.
Wes
July 21, 2004 at 10:15 pm
Check to make sure DTC is started before SQL Server is. There are several DTC issues and windows 2003 that will be addressed with SP1. We had simmilar issues with...
July 21, 2004 at 10:12 pm
Yep, rowcounts in EM are an estimation based off of your indexes on those tables which can be inaccurate to say the least.
Wes
July 21, 2004 at 8:14 pm
The only time I've seen an error is if profiler or the trace isn't shut down properly. it causes the trace file to be incomplete.
Wes
July 21, 2004 at 8:09 pm
Turn on the agent and save yourself a world of grief. There are a ton of good backup scripts here in the script library as well.
Wes
July 21, 2004 at 8:02 pm
I've also been using Sql Litespeed on several boxes backing up around a terabyte of data across all servers. I had some issues with the older 3.0.123 and up untill...
July 21, 2004 at 8:00 pm
We monitor around 100 servers here and found out the hard way that some IIS events fire every second or so and MOM will trap them. Our database got around...
March 19, 2004 at 8:40 am
memory will be your biggest issue. Citrix and SQL both chew up the ram. If you have to do it shoehorn in as much memory as possible. You can also...
March 19, 2004 at 8:36 am
The article may be here I would do a search. The one I am talking about is in the Sql Server Standard magazine. It isn't easy but it will make...
March 17, 2004 at 1:59 pm
If you have to have 115 unions then you have other problems than memory issues. You need to break the query up into pieces try subselects or dumping sections to...
March 15, 2004 at 9:43 pm
If for any reason your server can no longer log into mail you can try three things. One, run the xp stored procedures to start and stop mail. Two, Restart...
March 15, 2004 at 9:33 pm
The account will have to be a local administrator on the server or you will have to go and grant full permissions to everything that SQL Server needs on the...
March 15, 2004 at 9:28 pm
Viewing 15 posts - 181 through 195 (of 508 total)