There you go ...

SET TRAN ISOLATION LEVEL READ UNCOMMITTED

SELECT

ISNULL(DB_NAME(database_id), 'ResourceDb') AS DatabaseName

, CAST(COUNT(row_count) * 8.0 / (1024.0) AS DECIMAL(28,2))

AS [Size (MB)]

FROM sys.dm_os_buffer_descriptors

GROUP BY database_id

ORDER BY DatabaseName

That gives you memory usage...

Not sure if I understand your question correctly, but you create an Index based on the attribute that you want to use for partitioning. For instance, if you are planning...

Answering myself, and hope it will help someone.

On my testing environment, I fixed it this way:

-On the original server, script attach commands using T-SQL, this way (of course, use your...

It looks like a network problem to me.

Ask your IT guy or Network admin to check the switches, traffic and overall network status between your MS-SQL server and your target...

I would start with the SQL error log,...

Hi Grant,

Thanks a lot for reply.

Yes, I really like VMware. I actually tried Fusion but already have Parallels on my MacMini so do not know what to do. But I...

Any CU or SP requires SQL downtime.

Now, if the server needs a reboot or not it depends of what services are running at the time of the update. If...

Run a server side trace , that will tell you exactly how many pages are being read during execution, but should be the same data collected by a DMV

I am sorry to disagree... but for a SAN with actual mdf and ldf files there, I see no reason to defrag, specially if we are talking about TBs of...

"GO" is not a T-SQL command, that's a Microsoft's stuff. You use GO to create batches inside your T-SQL code but you should not use it inside an store procedure...

sqlsurfer101 (8/22/2013)

---

10,000 databases on a cluster? Not good architecture. I would like to be corrected by anyone if I'm wrong - Is there is a reason why that many databases...

How many pages do you have on that table or tables?

If I recall well, any table below 1k pages, a defrag will do nothing. So I would skip those.

Also, I...

jasona.work (8/23/2013)

---

So, I'm looking at possibly setting up a job in Windows (although I may have to manually trigger it) to defrag the disks in my servers. For the...

SELECT ss.sum_execution_count

,t.TEXT

,ss.sum_total_elapsed_time

,ss.sum_total_worker_time

,ss.sum_total_logical_reads

,ss.sum_total_logical_writes

FROM (SELECT s.plan_handle

,SUM(s.execution_count) sum_execution_count

,SUM(s.total_elapsed_time) sum_total_elapsed_time

,SUM(s.total_worker_time) sum_total_worker_time

,SUM(s.total_logical_reads) sum_total_logical_reads

,SUM(s.total_logical_writes) sum_total_logical_writes

FROM sys.dm_exec_query_stats s

GROUP BY s.plan_handle

) AS ss

CROSS APPLY sys.dm_exec_sql_text(ss.plan_handle) t

WHERE t.TEXT LIKE '%PROCEDURE NAME HEREt%'

ORDER BY sum_total_logical_reads DESC

I'm with Denny here...

Check the Tlog file utilization and VLFs for each database. I was able to improve recovery time of a 1TB database just doing that (above 200 total...