Memory

Hi All,
I have a question. SQL Server 's memory increase always. How can i release
SQL Server's memory?
When i do stop-start so SQL Server release memory. But i have to release
memory a different way.
Thaks alot.some reading on the subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
news:uXedWpM%23GHA.1224@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I have a question. SQL Server 's memory increase always. How can i release
> SQL Server's memory?
> When i do stop-start so SQL Server release memory. But i have to release
> memory a different way.
> Thaks alot.
>|||Thank you Tubor. I understand now my problem.
We use SBS and SQL Server 2000. SBS don't allow SQL Server to use over 2 GB
memory.
But SQL Server release memory when OS 's resources is low. But PC has 5 GB
RAM.
For this reason one couple of days after SQL Server performance very poor.
(So i think it use virtual memory probably.)
But i wonder that why microsoft doesn't fix this problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4hun9M%23GHA.1220@.TK2MSFTNGP05.phx.gbl...
> some reading on the subject:
> INF: SQL Server Memory Usage
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
> news:uXedWpM%23GHA.1224@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have a question. SQL Server 's memory increase always. How can i
>> release
>> SQL Server's memory?
>> When i do stop-start so SQL Server release memory. But i have to release
>> memory a different way.
>> Thaks alot.
>>
>

Memory

Hi All,
I have a question. SQL Server 's memory increase always. How can i release
SQL Server's memory?
When i do stop-start so SQL Server release memory. But i have to release
memory a different way.
Thaks alot.Why do you feel the need to release memory? By default sql server will
allocate and deallocate memory on the fly on an as needed basis. To release
the procedure cache issue a DBCC FREEPROCCACHE, to release the buffer pool
issue a DBCC DROPCLEANBUFFERS
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
news:uQkZWWP9GHA.1492@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question. SQL Server 's memory increase always. How can i release
> SQL Server's memory?
> When i do stop-start so SQL Server release memory. But i have to release
> memory a different way.
> Thaks alot.
>|||And some reading on the subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxqAkmQ9GHA.3740@.TK2MSFTNGP05.phx.gbl...
> Why do you feel the need to release memory? By default sql server will allocate and deallocate
> memory on the fly on an as needed basis. To release the procedure cache issue a DBCC
> FREEPROCCACHE, to release the buffer pool issue a DBCC DROPCLEANBUFFERS
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or
> opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
> news:uQkZWWP9GHA.1492@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question. SQL Server 's memory increase always. How can i release SQL Server's memory?
>> When i do stop-start so SQL Server release memory. But i have to release memory a different way.
>> Thaks alot.
>>
>|||Hi,
Make the SQL Server memory static; this will make sure the other application
gets enough memory.
But do not release the memory using DBCC FREEPROCCACHE or DBCC
DROPCLEANBUFFERS, this will cause
Data cache and procedure cache to get flushed and cause performance bottle
neck
Thanks
Hari
"Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
news:uQkZWWP9GHA.1492@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question. SQL Server 's memory increase always. How can i release
> SQL Server's memory?
> When i do stop-start so SQL Server release memory. But i have to release
> memory a different way.
> Thaks alot.
>

MDX in MS Reporting Services

Hi

(All using 2005 release)

I've written a MSRS report based on an OLAP data source which is working fine in the report designer but once I have deployed it to the report server & attempt to browse it I get the following errror:

An error has occurred during report processing.

Query execution failed for data set 'DataSet1'.
Line 1: Incorrect syntax near '{'. Line 1: Incorrect syntax near 'Tbl Acc Codes'

It seems to be pointing to an mdx error although I've constructed the query just by using the drag & drop tool.

Are there any known problems with MSRS & MDX & if not can any of you MDX gurus spot anything wrong with the qry:

SELECT NON EMPTY { [Measures].[Ratio Val] } ON COLUMNS, NON EMPTY { ([Tbl Ac Year].[AcYear].[AcYear].ALLMEMBERS * [Tbl Comparison Group].[Tbl Comparison Group].[Tbl Comparison Group].ALLMEMBERS * [Tbl Comparison Group].[Description].[Description].ALLMEMBERS * [Tbl Group].[Tbl Group].[Tbl Group].ALLMEMBERS * [Tbl Group].[Display Order].[Display Order].ALLMEMBERS * [Tbl Clients].[Tbl Clients].[Tbl Clients].ALLMEMBERS * [Tbl Acc Codes].[Acc Desc Hierarchy].[Description].ALLMEMBERS * [Tbl Acc Codes].[Acc Code Hierarchy].[Tbl Acc Codes].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [FE Benchmark] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Thanks :)

Wayne

Try and paste your query into MDX editor in SQL Managment Studio. It will allow you to perform a syntax check on your query.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.