Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
4,996 reads
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
2009-10-26 (first published: 2008-09-18)
5,869 reads
it's a .cmd file and I use shutdown.exe from the Resource Kit, though I'll be switching that to psshutdown because it honors the power down as well. It's manually executed by an administrator if needed. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-16
There is an option in Backup Exec (I've never used the option myself, so check out your documentation) to restore to a different location; it's similar to SQL Server's WITH MOVE. -SQLBill
2003-06-30
A real low-tech way would be similar to the method mentioned by stax68. Create a stored procedure to do the work. Set it as a job to run every minute (or whatever frequency seems necessary). The arguments indicating that the process should be run would be entered into a table from your calling program. When […]
2003-06-27
Replication is enabled for specific databases and should not effect how the others operate. However, depending on push or pull an where the distributor is they can chnge the server loads which does effect overall performance. And DTS is not the same as replication although you can create a custom datamove similar to the concept […]
2003-06-27
Thanks for your input I realized the problem...I had to also include the Dbname.table.columnname in the where clause..
2003-06-26
1 reads
I tried it a again: use master exec xp_cmdshell 'bcp "select * from dbname.owner.table where checkbit = 0" queryout e:\products.txt -c -Sserver -Usa -Ppassword' I get as an error the format for writing bcp commands...?
2003-06-26
Ok, I went back to BOL and looked at the syntax. The IDENTITY option is only available if you are adding a column. ALTER COLUMN allows you to add or drop ROWGUIDCOL but not IDENTITY. EM does it by creating a new table with the IDENTITY property, copying the data to it, dropping the old […]
2003-06-17
As a final note, you may want to go into Enterprise Manager and change the table in the Design View, then click Save Script button and see what SQL internally thinks is the best method for handling this...Sometimes this technique is useful in figuring out some of the trickier DDL constructs... Good luck!
2003-06-17
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers