Viewing 15 posts - 6,991 through 7,005 (of 9,244 total)
The following will set the max server memory to the value you specify in MB's
exec sp_configure 'show advanced options', '1'
reconfigure
exec sp_configure 'max server memory (MB)', 'set this'
reconfigure
exec sp_configure 'show advanced...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 2:15 am
arvind.1611 (7/5/2011)
The Stand-Alone SQL Server currently has 7 databases, with total database size of ~500GB. The Transaction log growth per day is around 25 GB.
thats the max size the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 2:06 am
Ol'SureHand (7/5/2011)
be careful before doing a full backup as this will break the transaction log backup chain.
No it doesn't, changing the recovery model from Full or Bulk Logged to Simple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 1:57 am
are you able to send a test email with no attachment?
Execute the following and post the full results, not just a subset
EXECUTE msdb.dbo.sysmail_help_account_sp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 10:34 am
GilaMonster (7/5/2011)
but it usually won't have time if windows is shutting down.
😀 especially if some monkey pulls the plug or holds the power button in for 4 secs 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 5:51 am
on a high traffic database how many transactions could take place in the space of a minute or even five minutes??
Have you ever wondered why when you shut down SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 5:37 am
Jayanth_Kurup (7/5/2011)
drop the indexes on the tables and run shrink database..........................then go ahead and perform your backup and restore followed by re creating all the indexes.
Please tell me you are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 5:31 am
Jayanth_Kurup (7/5/2011)
Also, i wasn't able to find...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 4:17 am
A faster shutdown, but a sloooooooooow startup 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 12:08 am
Syed Jahanzaib Bin hassan (7/4/2011)
SYS.DM_EXEC_SQL_TEXTthis is not DMV in bold?
Now you're just being pedantic. No, it's a function. The DMV suite is made up of views and functions. Stop trying...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 11:55 pm
This series of tests by Kendal Van Dyke give a better benchmark. It's worth noting that in most cases there isn't really much of a margin. View them and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 2:53 pm
Perry Whittle (7/4/2011)
Coolroof (7/4/2011)
windows authendicationI'm assuming you understand the implications of selecting that option?
can you execute the following on the sql server instance and post the results
EXECUTE msdb.dbo.sysmail_help_account_sp
:Whistling:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 12:02 pm
Jeffrey Williams-493691 (7/4/2011)
Perry Whittle (7/4/2011)
Jeffrey Williams-493691 (7/4/2011)
and it really does depend on how that particular SAN is configured and how the LUNs are carved out.
even right down to the HBA...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:23 am
timr-1113026 (7/1/2011)
sometimes you just have to hear someone give their perspective to start the thinking process... 🙂
The following in future may be helpful to trouble shoot these problems
RESTORE FILELISTONLY
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:21 am
Jeffrey Williams-493691 (7/4/2011)
Perry, that is exactly the point I was trying to get to - it depends 😉
i agree
Jeffrey Williams-493691 (7/4/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:06 am
Viewing 15 posts - 6,991 through 7,005 (of 9,244 total)