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...
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...
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...
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
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 😉
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...
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...
July 5, 2011 at 5:31 am
Jayanth_Kurup (7/5/2011)
Also, i wasn't able to find...
July 5, 2011 at 4:17 am
A faster shutdown, but a sloooooooooow startup 🙂
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...
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...
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:
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...
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
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)
July 4, 2011 at 10:06 am
Viewing 15 posts - 6,991 through 7,005 (of 9,244 total)