Afternoon,

I may be jumping the gun a little here but in addition to Jeff's requested information, some details regarding your disk subsystem may also be useful.

For example, are you using...

Hi Ratheesh,

You are probably not in a position to be able to share the information with us but which Banking Application are you looking to deploy?

I may be able...

As Abhay explains, the key driver to ensuring successful resolution to your issues is to target the source of the problem by identifying the specific T-SQL code / Stored Procedures...

SQL Server Row Versioning technology is quite a big subject area. May I suggest that you review the Microsoft White paper on the subject in the first instance. It will...

Hi there,

Can you confirm for me the disk queue length that is being reported for your backup drive?

You can verify this information by using the windows performance monitor and specifically...

I would consider setting the dev team up with their very own sandbox server.

You can initially install and configure SQL Server for them. After that the Dev team have to...

[/quote]

Hi John,

Thank you for taking the time to present...

The question seems somewhat missleading given that you can enable/configure FILESTREAM technology soley via the use of the SQL Server Configuration Manager.

FILSTREAM is then enabled/configured within the CREATE DATABASE statement.

http://technet.microsoft.com/en-us/library/bb933995.aspx

I...

Can you please post the T-SQL statement you are issueing in order to drop the index.

If the failure occurs on the primary server then the recovery process is exactly as would be required in order to recover a database that is not being log shipped.

The...

Have you attempted to connect using the Dedicated Administrator Connection (DAC)?

See Books Online:

http://msdn.microsoft.com/en-us/library/ms178068.aspx

You need to qualify what is consuming the CPU.

If it is indeed SQL Server queries then you need to investigate further in order to identify which specific queries are responsible.

Here...

samsql (5/14/2009)

---

John site says this do this mean i hav to add a memory....

If the Total Server Memory (KB) counter is consistently high compared to the amount of physical memory...

Ok so you have created a local drive mapping on the server to a NAS drive on the network somewhere called T:\ for example?

If you browse to my computer under...

I assume you are looking to just move user databases and not the system databases?

Check out the following Microsoft reference via the magic of Google and the phrase "SQL Server...