I would run sp_who2 to check what processes are using up CPU and if any blocking is happening. If you have the money, I would recommend using NetIQ's DiagnosticManager. It monitors real time stats on your server and it also has a feature callew Worst Performing Queries/Stored Procedures/Batches. It actually tells you the queries that […]
2004-04-14
2004-04-14
I created a program that will dettach a database at night so it can be backedup to regular tape (via our system backup) and then attaches it after backup.The dettach works great but attaching does not work.Any ideas why?Dim oSvr As New SQLDMO.SQLServer oSQLSrv.Connect "servername", "user id", "password" oSQLSrv.AttachDB sDBName, FileName1 & ", " & FileName2 […]
2004-04-08
2004-03-19
Mike:I believe that you are on to something. However, I believe that it has to do with the Server and not with Client. You said “your tests involved changing the Client configuration only”. Was this on the Client or on the Server? The remote clients do not have the client Network Utility installed on their […]
2004-03-16
I have a very larre (and growing) table which contains a PK and another column of the type text.The text column contains XML, and I wish to search for the occurance of the various XML tags in the table.Currently I can use LIKE statements to pull out matches. Will I still be able to do this […]
2004-03-16
2004-03-16
http://www.sql-server-performance.com/sql_server_log_shipping.asp is a really good covering of this subject. I have based all my log shipping work on it with great success. I hope it helps. Regards from Paul
2004-03-16
All, Thanks so much for your responses.Based on these two articles http://support.microsoft.com/default.aspx?scid=kb;en-us;814848 and http://support.microsoft.com/default.aspx?scid=kb;en-us;240240 this is our problem. To quickly rap them both up; files and folders have two names associated with them a long name a short name. Short name are applied as applications are installed. When a backups is preformed the short name […]
2004-03-12
2004-03-01
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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