Agree with everyone is saying about the standby...seems like we're missing something.

To answer your question, simple take a full backup on the current server, then restore it to the new...

bubby (2/13/2014)

---

SQL Sever is 2008R2

Database size = 38 GB

It is simple database

When I run the table size the biggest table is 81 Mb. total of tables is not even 1...

Try this:

Open Windows Explorer

Find a .TXT file and Right-click the file

Click "Open With"

Click "Choose Default Program"

Select "Notepad" and place a check in the "Always use the selected program to...

Not sure if this helps but I did find a link that might offer you a direction to go in:

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx

I know this is a mute point, but I personally wouldn't go looking for performance problems for a slow running web page without first being told what is being called...

I don't believe this is possible due to "scope" (as someone already pointed out). Your variable @dbstatus isn't in scope when the sp_executesql is executed therefore cannot be assigned...

Sort by duration/logical reads - right-click to view the execution plan

(and the script you ran prior, you need to run that on the database in question)

My mistake, Add N in front of the @dbstatus nvarchar(500) output - like so (you will need to rmeove the spaces in "d eclare"):d eclare @var nvarchar(max) = '@var1',

@sql nvarchar(max)

declare...

Two questions: 1) Are you getting an error? 2) Did you restart the Reporting Service after making the change?

Change your D-ECLARE @dbstatus varchar(500) and @dbstatus varchar(500) output to nvarchar(500)

I believe this is related to this post (same question)

http://www.sqlservercentral.com/Forums/Topic1541179-391-1.aspx

In this case, you need to find the problematic query and review its execution plan - can you pinpoint which query...

Not quite sure if i am reading your question properly but...you would see the difference in read/writes because 1) the table the non-clustered index was created on is being written...

What exactly are you asking for help with?

Does the page contain a call to a database? If so, what is it calling? A procedure, a SELECT statement, etc? ...

Thanks Keith - this answers my question: "Note This trace flag is not required for customers who use Enterprise 64-bit editions or Developer 64-bit editions of SQL Server. Enabling this...

Gail, apologies in advance for hijacking the thread but can you confirm something for me? In that chapter (4) the Lock Pages in Memory states:

Initially, in SQL Server...