Viewing 15 posts - 1,471 through 1,485 (of 2,496 total)
You need to talk to SAP. They will have LOTS of experience on how big the database should be with your workload, and how to tune it. SAP...
February 18, 2009 at 3:31 am
If you want to move tempdb while SQL is running, you can use ALTER DATABASE to add new files to tempdb. You can then use SHRINKFILE with EMPTYFILE to...
February 18, 2009 at 3:22 am
You cannot have a dedicated buffer pool for tempdb. All databases share the same buffer pool.
In a large system there would be performance benefits to be gained if you...
February 18, 2009 at 3:18 am
PS If it works on one node of the cluster and not on the other, this is telling you there are differences in permissions between the two nodes.
February 18, 2009 at 3:10 am
Try some testing where the proxy account is not a local admin and where it is a local admin.
If it fails when the proxy is not a local admin and...
February 18, 2009 at 3:09 am
It is important to set the maximum memory limit for 64-bit SQL Server. The memory reported as available to SQL Server includes the page file size, so if you...
February 17, 2009 at 4:08 am
it was fine until a manger told System engineering to stop it
I think you need to discuss this with your manager. If anyone who thinks they have some authority...
February 17, 2009 at 4:02 am
I think you have a couple of options...
1) Try the latest CU update for SP4. See http://support.microsoft.com/kb/894905/ for details. The problem you have may be fixed in a...
February 17, 2009 at 3:54 am
Does the log file for the hotfix install give any clues? Assuming the hotfix is a .msi you can add a parameter /LOG "C:\hotfixlog.txt" If you have a...
February 16, 2009 at 6:13 am
On SQL 2000 the space used figures are not maintained very well. You should plan to do a DBCC UpdateUsage maybe once per week to re-sync the figures.
February 16, 2009 at 6:06 am
If the accounting software created the backup, it probably has a tool to restore its backup. If so, you will need to use that tool to do the restore.
February 13, 2009 at 2:50 am
1) Who writes these scripts? Getting these right is a skill worth exploiting.
2) Have you seen how complex SQL Server 2008 is? It is like really complex! :)...
February 13, 2009 at 2:47 am
If a job that is cancelled after running a long time has been doing SQL insert/update/delete logic all that time, it will probably take longer to roll back than it...
February 13, 2009 at 2:43 am
It is very likely your 32-bit SQL Server 2000 instance is running on a 32-bit edition of Windows. All 64-bit editions of SQL Server will only run on 64-bit...
February 13, 2009 at 2:40 am
Another place to look is if the proxy account has read & execute rights on the SQL program folders. Also, check if the proxy job is trying to save...
February 12, 2009 at 7:23 am
Viewing 15 posts - 1,471 through 1,485 (of 2,496 total)