Tag Info

Hot answers tagged

5

First and foremost, before to mangle with storage, you should be 100% sure that your bottleneck is really related to disk/IO configuration. It this is the case, an iSCSI share can be faster than a NFS one, but in specific scenario only (small random read/write packets). SQL servers can be one of these scenarios, so if you are sure that your problem is ...


4

I've not heard that iSCSI is better than NFS for SQL VMs, however if you do elect to create them, I would create the datastore on the ESX level, not install an iSCSI initiator on the VM. One thing you need to be careful about is thin provisioning on the Netapp. The way they do block devices is different. You can find yourself with an offline LUN if you ...


4

First things first: If you want to improve the performance of a VM you have to know where the bottleneck is. Improving storage performance doesn't help you if your environment lacks e.g. CPU performance. I don't think changing your storage protocol from NFS to iSCSI will help you much. There are dozens of other parameters that influence your storage ...


3

Not really knowing what server you are actually looking at we can only guess. Adding to what GregL and Jim B said. My guess is you're migrating from Server 2003 Standard, IIS 6.5, Access 2007 using ASP classic code pages connecting via OLEDB static. You might be planning on importing your Access using Upsizing Wizard (which kind of works most of the ...


3

It's possible that this is a bug in SQL: When you run a Full-Text query that uses compound words in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2, you receive the following error message in the Error log file: Date Time spidID Error: 701, Severity: 17, State: 123. Date Time spidID There is insufficient system memory in ...


3

In general, SQL Server is using Windows SChannel services for transport encryption. So you should be able to restrict protocols and ciphersuites by manipulating the SCHANNEL-related registry keys in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL. For details, see KB245030 and the relevant section in Technet Documentation for ...


2

Assuming I don't want any new features of 2012 is it as easy as restoring the 2008 databases on the new server? It is - plus setting trace flags for the server to force the old behavior of the query optimizer, I think. If that works, I guess it's not the recommended way, Why not? It totally looks like the recommended way to me.


2

Per the installation documentation: https://msdn.microsoft.com/en-us/library/aa770536(v=bts.10).aspx Configuration After Server Setup You can install the Server software without running the Configuration Tool, and then run the Configuration Tool later (on the Start menu). Eventually, however, you must run the Configuration Tool. To do this, ...


2

In an n-disk RAID5, you need n-1 disks to read back the data. If two drives are dead, no other disks will contain a full set of data and you have to resort to your backup. For speed purposes, data is striped over the disks to allow for faster reads.


2

Have you tried right clicking on the window in Task Manager on the application tab and choosing maximize? That usually works for me.


1

The usual reason to go with backup/restore is that no downtime for the source database is needed. In my opinion, if you can have a downtime, detach/attach will be perfectly fine. If you talk about big database files (~ >= 100 GB) and time is an issue, backup/restore could be faster because only used pages of a database file are backed up, whereas ...


1

First off, as TomTom already stated, yes it is possible. Using a backup / restore procedure is the proper way to upgrade your database. However, you will still need to do some other actions. You will need to migrate the SQL server logins to the new instance. You will need to test if your app doesn't use features that were removed. Most notably here is the ...


1

No, a hacker can't 'steal your VM and gain complete access'. They'd need to hack into the VM management interface and if they end up there, your government department has much bigger issues. Running both IIS and SQL on the same server is technically fine, but whether or not it's a good idea really depends on whether or not your load profile allows it. If ...


1

I Made TRUSTWORTHY = ON in the database and the SP executed without any problem by the Message Queue. Thanks !!



Only top voted, non community-wiki answers of a minimum length are eligible