Viewing 4 posts - 1 through 4 (of 4 total)
The memory allocation of SQL will be your first point then run a profile and monitor your SP's and the execution time of them. There is no engine difference beteen...
November 11, 2004 at 12:37 am
Hi
you can monitor the servers automatically bu generating daily reports, i was part of a four man team that monitored 260 odd servers with about 2300 user databases. We did...
November 10, 2004 at 4:47 am
A Domain account which has local admin on your SQL Server, this is the best account to create and use for your SQL Services. Never use Local System Account.
your jobs...
November 10, 2004 at 4:41 am
Hi
Have you had a look at the re-compilation of the SP ?, try dropping the SP and recreating it and after that drop and recreate your indexes.
cheers
November 10, 2004 at 4:38 am
Viewing 4 posts - 1 through 4 (of 4 total)