December 26, 2011 at 3:11 pm
Can't seem to find anything on this, seems like it would be possible. Batch job to stop and start agent and sqlserver in a scheduled task? Gotta think there is a better way!
Thanks for any help!
December 26, 2011 at 3:16 pm
Why do you want to do this?
Scheduled task would be the way to go, if you were going to do something like this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 26, 2011 at 3:40 pm
Scheduled task via batch and net commands.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 26, 2011 at 5:40 pm
Instance is running on a VM and I'm trying to keep memory usage to a minimum.
December 26, 2011 at 11:45 pm
It may sound silly but is downtime of Server acceptable? Is it DEV / Demo / Test Server?
In general it’s not a good idea. If you provide us more details on Database Environment & its usage, we might help you better.
December 27, 2011 at 3:34 am
tnelson-735283 (12/26/2011)
Instance is running on a VM and I'm trying to keep memory usage to a minimum.
Then set server max memory to an acceptable value and SQL will limit its memory usage to that plus a couple hundred MB more.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply