Thx All resources are available. space ok, BUT, which i know can affect performance but not connection timeouts, the tempdb has too many files....
We have a SQL 2008 cluster, and are having increasing, sporadic,and constant timeouts and dropped connections. Even with our local SSMS on the server...
We have a 64-bit SQL Server and have assigned Lock Pages in Memory. As soon as you add the “Lock Pages in Memory†privilege for the service...
Thanks, but I realized I would probably want to get all this info from current info, and not historical? dm_exec_requests and dm_waiting_tasks seem...
Ok,this should be fairly simple, but I'm missing something. Most of this could be derived out of the DMV sys.dm_os_wait_stats. CPUTime +...
I know a great new product that just might give you the performance boost you need! Pearl Knowledge Solutions is a local vendor, so you can contact...
I guess what we're looking for is 1) Best practice layout for data, log, tempdb on a SAN; and 2) What space is required % for indexes and backups....
Have some questions as we figure out best practice disk layout of sql server on SAN 1. Does SQL benefit from increased drive letters? The 3Par...
Thx for quick reply! I'll search, but it would be great if you can post the direct link.... What about the Upgrade Advisor? Much value?
Hi, all: I have a planned upgrade from 2000-2008 upcoming, and need tips on what I need to know for sp_configuration settings. For example,...
I have a question. I know, that you can log ship upstream from SQL Server 2000 to SQL Server 2008 but you cannot Log Ship downstream from SQL Server...
I am installing a SQL Server 2008 instance on Windows 2008 Cluster x64 bit. It got all the way to the end of installation and then error: Cluster...
Hi, so I got a system exchange, and I went from XP to Window 7 (64bit), and now I can't seem to install SQL Server 2008. W7 comes with .NET 3.5, and...
thanks, Satya! The reason why not to use DB Mirroring, is that the "secondary" needs to have updates and inserts made to them. Even with a snapshot...
Here is what I did, please tell me where there issues are: 1. Created two SQL 2005 servers (primary & User) 2. Created a DB on each server...
I need the best method for updating changes one way, based on a timestamp column. I can't use replication, b/c the databases will be refreshed...
What is the best way to copy a billion rows from one-table to another in SQL? Could I use an INSERT INTO...SELECT? - how would this affect...
I'm trying to come up with a solution. Have a DB around 1TB+, that receives Batch update/loads throughout the day. This of course slows to a crawl,...
hi. i've been looking for a way to enforce the ownership of a sql agent job via the Policy Mgmt framework. If for ex, you want to have all your...
Separate names with a comma.
