Viewing 15 posts - 676 through 690 (of 1,155 total)
You can't reduce the TempDB usage by increasing the number of Tempdb files.
Check this link to troubleshoot insufficient disk space in TempDB
http://msdn.microsoft.com/en-us/library/ms176029.aspx
...
January 20, 2011 at 1:10 pm
Is this a job created by a Maintenance Plan or is this a job running SSIS package.
...
January 20, 2011 at 1:04 pm
That should be fine. But run the reports during the less busier times.
...
January 20, 2011 at 12:52 pm
Run a perfmon counter log for 24 hours and collect the following the counters to identify the Memory Pressures
Memory: Available Mbytes
SQLServer:Buffer Manager\Page life expectancy
SQLServer:Buffer Manager\Pages/sec
SQLServer:Memory Manager\Memory Grants Pending
SQLServer:Memory...
January 20, 2011 at 12:41 pm
Also Is there any specific reason to use Max Degree of Parallelism of 4 ?
...
January 20, 2011 at 12:37 pm
Check the second node of the job history that could have a detailed message.
If not check the SQL Server Logs or Windows System logs to identify any issues that could...
January 20, 2011 at 12:35 pm
Page file size is extremely low. It should be atleast twice the size of the physical RAM on the server.
Also Run a perfmon counter log for 24 hours and collect...
January 20, 2011 at 12:31 pm
It should be fine except for the clustered indexes. But please test it on the test machine before implementing.
...
January 20, 2011 at 11:14 am
They usually go hand in hand. Centralized SSIS doesn't help you in a significant manner.
...
January 19, 2011 at 4:43 pm
Please check the maintenance plan log file to find the actual reason for the failure.
...
January 19, 2011 at 3:40 pm
1. Because VAS is assigned by the OS to the applications and then is mapped to the available physical memory or the page file. You are restriction the extent of...
January 19, 2011 at 2:36 pm
SELECT @@VERSION
Thank You,
Best Regards,
SQLBuddy
January 13, 2011 at 7:08 pm
Peter Trast (1/13/2011)[hr
Just remember that Resource Governor is new to SQL Server 2008 and this is a 2005 question.
Maybe it is time to upgrade? 🙂
And this is exactly the...
January 13, 2011 at 3:24 pm
You can't allocate memory at the individual query level.
...
January 13, 2011 at 11:52 am
If you restart your instance, then you should start with a new TempDB database with the default size. But this should be your last option.
...
January 13, 2011 at 11:48 am
Viewing 15 posts - 676 through 690 (of 1,155 total)