Viewing 15 posts - 541 through 555 (of 1,155 total)
SQL Server will try to use all the memory (64 bit) if you don't limit its usage by using Max Memory.
Good practice on dedicated SQL Servers is to set Max...
September 13, 2011 at 5:14 pm
The basic recommendations is to split Tempdb into multiple files and put them on seperate spindle, Size them adequately & Properly, set a good auto growth size.
Check this one...
September 13, 2011 at 5:11 pm
September 13, 2011 at 5:06 pm
Generally , it is recommended to do the reorgs daily after the nightly backups along with update stats.
Do the Rebuilds once in a week. If you have too big databases...
September 13, 2011 at 4:57 pm
Adv: Read_committed_snapshot is used to reduce Blocking
Disv: 1. Heavy use of TempDB.
2. Db needs to be in single user...
September 12, 2011 at 6:01 pm
Use this for that task..
SELECT * FROM sys.dm_os_performance_counters
WHERE counter_name IN ('Total Server Memory (KB)')
Thank You,
Best...
September 12, 2011 at 5:56 pm
Check this counter ..
Total Server Memory (KB) to see if SQL Server is hitting that Max Mark.
...
September 12, 2011 at 5:35 pm
Use an expression something like this ExecuteSQL('Numeric', select count (*) from ......................) > 0 and create a condition and a policy based on this condition.
select count (*) from ...................... query...
September 12, 2011 at 5:24 pm
You have 3 options
1. With Log shipping, the users can't do the reporting during the Log restores..
2. With DB Mirroring, you need to use snapshots for the reporting purposes...
September 12, 2011 at 5:13 pm
IP addresses work very well in case of the Linked Servers. We had similar resolutions in the past. But this works only as long as the IP doesn't change for...
September 12, 2011 at 5:06 pm
Create the second table on the primary server itself which will be quicker and easy. Creating on the destination server defeats the purpose.
...
September 12, 2011 at 4:58 pm
After all the efforts that you have made, I would recommend to contact MS customer support to resolve this. That would save you lot of time and effort.
...
September 12, 2011 at 4:55 pm
I never meant to set Max Memory to be equal to the total memory on the box. You need to set something like Max Memory = (Total Server Memory -...
September 12, 2011 at 4:52 pm
Jeff Moden (9/11/2011)
sqlbuddy123 (9/11/2011)
If you configure SQL Server to maximum memory and set Lock pages in Memory...
I'm not sure if I'm reading that right so forgive me if I'm taking...
September 11, 2011 at 11:09 pm
Jeff got it perfectly right. Just use CREATE Table and add an identity column to it.
...
September 11, 2011 at 11:03 pm
Viewing 15 posts - 541 through 555 (of 1,155 total)