Viewing 15 posts - 1,441 through 1,455 (of 4,745 total)
alexander.suprun (10/21/2011)
george sibbald (10/21/2011)
a max memory setting of 118GB is the buffer pool only, other SQL caches will add to that.george, where did you get this?
experience, lots of DBA work...
---------------------------------------------------------------------
October 21, 2011 at 4:17 pm
post the results of this query:
SELECT TOP 10
[Wait type] = wait_type,
[Wait time (s)] = wait_time_ms / 1000,
[% waiting] = CONVERT(DECIMAL(12,2), wait_time_ms * 100.0
...
---------------------------------------------------------------------
October 21, 2011 at 1:57 pm
whats does the available memory perfmon counter say?. How much memory is SQL actually using?
a max memory setting of 118GB is the buffer pool only, other SQL caches will...
---------------------------------------------------------------------
October 21, 2011 at 1:10 pm
If the schema (I presume that is what you are going to be using) are not related perhaps they should not be in the same database. What if you need...
---------------------------------------------------------------------
October 21, 2011 at 1:00 pm
I still have a fair number of SQL2000 installs out there. I am trying to upgrade or retire all of them but it is difficult as the application support people...
---------------------------------------------------------------------
October 21, 2011 at 3:25 am
MarkusB (10/20/2011)
I just noticed that the OP wants to migrate maintenance plans from SQL 2000 to 2008. So SSIS isn't an option after all.
so he does.
The ops only choice is...
---------------------------------------------------------------------
October 20, 2011 at 8:23 am
whats the state_desc value in sys.master_files for this offending log file?
if it is 'offline' and you have issued an emptyfile and remove file a transaction log backup could remove this...
---------------------------------------------------------------------
October 20, 2011 at 7:59 am
why? Are you using a case sensitive collation?
---------------------------------------------------------------------
October 20, 2011 at 6:28 am
Markus, having done so would they work on the new server? Are not the maintenance plans heavily tied to the server they were created on?
---------------------------------------------------------------------
October 20, 2011 at 6:20 am
got enough space scripts yet? I have some more 😀 (one of 'em written by Jeff)
---------------------------------------------------------------------
October 19, 2011 at 10:45 am
A heap is a table without a clustered index. Reindexing would not defragment the base data.
Views occupy no space, they are just queries.
heres a couple of queries to run in...
---------------------------------------------------------------------
October 19, 2011 at 10:31 am
you had 2GB worth of growth because of the growth factor of 10%, the mdf was almost 20Gb, so it grew by 2GB. When it was only 3GB it would...
---------------------------------------------------------------------
October 19, 2011 at 10:13 am
whats the growth factor on the database mdf file?
when you back the database up, how big is the backup?
---------------------------------------------------------------------
October 19, 2011 at 9:52 am
you could do that. Set up logshipping in the normal way then disable the backup job.
As stated above write a process to check log full percentage which then executes...
---------------------------------------------------------------------
October 15, 2011 at 8:19 am
As Lynn has said if you dont want log backups, put the database in simple mode, it doesn't matter what the vendor says, they rarely know very much about database...
---------------------------------------------------------------------
October 13, 2011 at 2:01 pm
Viewing 15 posts - 1,441 through 1,455 (of 4,745 total)