Posted by hieuhotrung on 3 November 2009 Excellent Posted by flavio on 4 November 2009 In your article you show a table with suggested MaxServerMem Setting for x64 servers... Posted by Denise McMillan on 17 March 2011 Do you have a list of recommended settings for 32 bit? For example, Windows 2003, 32 bit, 8Gb ram, with SQL Server 2008 sp1
In this database we configured mirroring but right now mirror server is not connected but on my priniciple server satus is sinchronized.i tired shrink file and take log backup .but still persisting the problem . Even I have noticed in couple of my consulting engagements and suggested the second solution (They need the point in time recovery) for better maintenance of the transaction log file
How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64 - Server Fault
Anyone know what I am missing? There are many posts around the web, but there seems to be a lot of confusion and outdated links to Oracle's download page
How to analyse SQL Server performance
However data-write can interfere with disk IO, specially with log writes, and cause delays in log flush waits that are very visible as application performance drops. This kind of information is a real treasure cove to identify problems in an application: Large execution count Queries that are run frequently are the most sensitive for performance
SQL Server - How to determine ideal memory for instance? - Database Administrators Stack Exchange
It was allocated to the machine because that was the amount of memory the physical machine had, because of a vendor recommendation, or because we threw out a best guess as to how much memory we thought the instance would require. What would be the best way to determine an ideal amount of memory per instance that is actually active and being used? Are there other counters we should be looking at in addition to page life expectancy? We have instance that have PLE's of 10k+ and others that have 100k+
How to export SQL Server 2005 query to CSV - Stack Overflow
You may be able to paste directly into a text file (can't try it now) Or "Results to file" has options too for CSV Or "Results to text" with comma separators All settings under Tool..Options and Query.
windows - How do I get SQL Server to release its memory? - Server Fault
But if all the memory is used by the buffer pool, then evicting the entire buffer pool will result in tremendous performance degradation and huge IO load. You could probably write something which hits the win32 API directly to do so, but as far as I know the only way to trigger Windows to request memory back is to cause it to need more memory for another process
How to use GROUP BY to concatenate strings in SQL Server? - Stack Overflow
I would have added it as a comment, but I don't have enough points yet :) I was using this idea for a view I was working on, however the items I was concatinating contained spaces
Is there a query to retrieve the partition ranges? In my example I am expecting to see the list of current partition ranges like Jan2011, Feb2011 Thanks. USE TestDB; GO --- Step 6 : Insert Data in Partitioned Table INSERT INTO TestTable (ID, Date) -- Inserted in Partition 1 VALUES (1,GETDATE()); INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2 VALUES (11,GETDATE()); INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2 VALUES (12,GETDATE()); GO Step 7 : Test Data from TestTable Query TestTable and see the values inserted in TestTable
No comments:
Post a Comment