hello experts, can anyone please help me to find out what query was executing in management studio in this deadlock?

thanks

2016-02-24 19:45:38.48 spid21s process id=process561d288 taskpriority=0 logused=10000 waitresource=DATABASE: 12 waittime=882 schedulerid=3 kpid=4160 status=suspended spid=89 sbid=0 ecid=0 priority=0 trancount=0 lastbatchstarted=2016-02-24T19:17:39.507 lastbatchcompleted=2016-02-24T19:17:39.507 clientapp=Microsoft SQL Server Management Studio - Query hostname=SQL01 hostpid=492 loginname=abc\sqladmin...

Thanks Perry,

I don't want to uninstall and install SQL Server. I want to move only user databases to new mount points.

Currently, installation and System databases are default location E:\Microsoft SQL...

Hi ApploDB,

Can you pleas let me know how to calculate IOPS on my current SQL Server in production?

We are not using linked servers. This sql instances hosts SharePoint Databases.

DBCC completed with no errors. Do you know what will be possible cause for this error?

I did find a way from the below link:

http://blogs.msdn.com/b/tfssetup/archive/2012/01/09/exporting-selected-tables-from-a-sql-database.aspx

We have more than 50 databases. Using import/export is time consuming. Is there any scripted way to do this?

So, do we need to take full backups and send to DR location and reconfigure log shipping natively?

Our SharePoint databases are very large (10 databases, total size 2 TB). So...

So, do we need give read/write permissions to sql service account in Data Domain file share? can you please advise?

Hi Kevin,

EMC Data Domain, has ddbmsqlsv.exe. How you are incorporating this exe in Ola's backup script? Can you please advise.

ddbmsqlsv.exe -c STAGEVS.abc.com -A STAGEVS.abc.com -S 2 -l full -N "DDBackup_DB1"...

Hi Old Hand,

can you please share the power shell backup and restore scripts. I'm struggling to backup to Data Domain.

Thanks

yes, log backups are successfully applied every 15 mins and they are in sync.

Hi,

I ran a sample SQLIO stress test using the below parameters in a batch file called Test.bat files.

I'm just using 100 MB file to start.for the next run, I'm going...

I'm able get the offending query from profiler after selecting the below events in profiler and its taking 16 to 20 seconds in SSMS.

SP:StmtStarting ,SP:Stmtcompleted ,RPC:Starting , RPC:Completed and ...

Yes, I noticed that the sql queries are causing the PLE to drop...