How many reporting servers (subscribers) do you have? If you are planning to use Reporting Services in the future, keep in mind that you can only use...
Thanks Luis, I'll have a look.
I have an environment that hosts SQL Server databases for a large number of clients. Some of these client require that we send them a copy of their...
You shouldn't have a problem shrinking it just like any other user database. Keep in mind that it's kept in FULL recovery mode by default.
Another option is to use a 3rd party product, such as Lumigent Audit DB.
You don't have many options here if you're using SQL Server 2005. You can use Login Auditing at the server level, which will track server logins in...
I know you can ping it and RDP is working, but maybe Windows Firewall is enabled without an exception for port 1433?
What do you mean by "virtual machine"? Are you running two cluster nodes that are virtual machines? If your cluster is truly active/passive, it...
What are the settings for failover? I find failback to be extemely dangerous. If there is a problem with node 1, and you fail things over, it could...
I did the same thing this morning.....scheduled a job to restart WMI nightly. It makes a big difference!
I've done a little research, and I think that there are some buggy WMI calls being made on clusters that run SQL. On a hunch, I restarted the WMI...
Did you find a resolution for this? I'm having the exact same issue across all of our clusters...
I've heard that read caching can cause double reads with the CX series, I've tried disabling it in the past and didn't see a difference. So you're...
Any luck with this? Have you thought about installing WireShark on the SQL box to help identify other possible sources?
Weird, is this a CX series EMC? Are the drives fibre channel or SATA/SCSI? I know you've looked at the average disk queues in PerfMon, what does...
Also, you could run a SQL Profiler trace to see where connections are coming from. If you use the Audit Login filter, it will show you the...
Well, unlike the Cuckoo's Egg, you don't have to worry about supporting DEC VAX [:)] Not sure of what to tell you on the IP forwarding, my Cisco...
Do you have the source code for the applications utilizing this cluster? If so, are you source control? I would do a blanket search of any source...
What is the "controllerservices" account? Is this a windows account that is local to the server or a domain account?
You can run this query, and it will show you all running processes: sp_who2 active Find the value in the SPID column for that particular process,...
Separate names with a comma.
