Viewing 15 posts - 1,651 through 1,665 (of 6,105 total)
Good point. If it's a really bad query eating up memory and taking forever to execute, it's going to hold locks that'll show up. This will catch such a query...
October 4, 2007 at 8:50 am
Any related to memory usage by SQL Server, # of connections, lock timeouts/deadlocks, and the standard battery at the OS level (memory, processor, disk, etc.).
October 4, 2007 at 8:02 am
The words "are not an SSIS package" should read "are now an SSIS package."
October 4, 2007 at 7:57 am
71 camaro (10/4/2007)
1: I was told by the vendor to install with sql2005 sp1. I was also told you need to install integration services for the maintenance plans . Do...
October 4, 2007 at 7:56 am
This is most likely an application issue. I have seen it when an application was leaking connections (wasn't explicitly closing out the connection but calling an open for a new...
October 4, 2007 at 7:49 am
It was worth a shot. Running a server side trace is likely to kill you... I have seen that issue when someone was doing a trace, too, come to think...
October 4, 2007 at 7:27 am
Did you have any performance counters monitoring the vitals?
October 4, 2007 at 6:41 am
The network error could also be the operating system's redirector getting confused, although this usually happens with respect to file shares (I'm assuming your're connecting with TCP/IP and not named...
October 4, 2007 at 6:26 am
When running xp_cmdshell, if the account you are using is a sysadmin within SQL Server, it acts on the operating system as the SQL Server service account (not necessarily the...
October 4, 2007 at 6:20 am
I've seen this when SQL Server is overwhelmed by connections, but that was on hardware substantially less than what you've got.
October 4, 2007 at 6:16 am
Active Directory = Windows domain (which are serviced by domain controllers)
SPN = Service Principal Name
Starting with Windows 2000, the default security mechanism is called Kerberos. Kerberos allows a client...
October 4, 2007 at 6:08 am
I'm ineligible for the prizes, but I thought I'd give my two cents.
My first break writing was over at the old swynk.com. Back then, Brian Knight was the content editor...
October 3, 2007 at 10:26 pm
1. Yes.
2. No.
The reason for #2 being no is that from a security perspective, there is the Principle of Least Privilege. This principle says that you give only the rights...
October 3, 2007 at 8:48 pm
hmbtx (10/3/2007)
Remember, all users run the same program. That program connects to SQL Server with the same SQL Server login name.
If the program connects with a SQL Server login, not...
October 3, 2007 at 8:41 pm
hmbtx (10/3/2007)
Does anyone know of what settings on a PC would cause the nt_username not to be returned? The PC is running Windows XP.
This isn't determined by the PC configuration....
October 3, 2007 at 6:22 pm
Viewing 15 posts - 1,651 through 1,665 (of 6,105 total)