Viewing 15 posts - 31 through 45 (of 112 total)
Temp db will grow with misuse of temp tables, Cross Joins, large queries, aggregates
Check for those using the profiler ...
check this thread out ... http://www.sqlservercentral.com/Forums/Topic910208-146-1.aspx
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
January 14, 2011 at 5:29 am
**UPDATE **
I checked the PRD server where the mails are still working and ran
SELECT * FROM sys.service_queues
execute_as_principal_id = 1 on sp_ExternalMailQueueListener and sp_sysmail_activate
On the QAS server
execute_as_principal_id = -2
and checked http://msdn.microsoft.com/en-us/library/ms187795.aspx
ID...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
January 14, 2011 at 2:32 am
Database mail has stopped once again this morning ...
What can cause it to stop?
I ran
sysmail_start_sp
alter queue ExternalMailQueue with status = on
an I'm sending mails again ...
any leads?
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
January 11, 2011 at 11:42 pm
MS SQL 2005 Standard Edition with SP2 x86
Microsoft Windows Server 2003 with SP2
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
January 11, 2011 at 4:32 am
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
December 8, 2010 at 2:08 am
what switches did you change in the boot.ini file?
3GB and PAE??
I'm asking because of your max and min memory settings above ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
December 8, 2010 at 1:04 am
why do you want to shrink the tempdb?
is the drive it is currently on running out of space? if this is the case move it to a larger drive ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
November 9, 2010 at 3:09 am
I would suggest you implement Gail's suggestions ...
change to bulk logged receovery model
implement reindex or reorganize index via a script depending on the fragmentation levels ...
and DO NOT SHRINK the...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 28, 2010 at 7:42 am
thanks Paul 😀 will check on what backups are available and find out if they want a restore or accept the dataloss ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 22, 2010 at 2:09 am
issue with a user table ...
SELECT name, type_desc FROM sys.objects
WHERE object_id IN (738817694) returned HIP7_IPSEventParameterUSER_TABLE
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 22, 2010 at 1:42 am
thanks 😉 I thought as much
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 22, 2010 at 12:21 am
how often do you backup those db's?
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 15, 2010 at 2:18 am
what version of 2005 and what is the SP installed also???
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 7, 2010 at 4:59 am
bad indexes, statistics can also coz SQL cpu usage to go crazy ...
Did you run a sql trace to confirm that it is the bad sql statements in the program...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
September 29, 2010 at 9:04 am
what step is failing in the maintenance job?
What other job is running while this 1 is failing?
what transaction job is running every 15min? Tlog backup?
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
September 29, 2010 at 7:49 am
Viewing 15 posts - 31 through 45 (of 112 total)